Combining multiple columns into one column with SQL

[mdlueck]

For a combo box control, I really need to display the result of concatenating two separate DB columns together. I have tried various syntax I am finding on the Internet... however none have worked with Access 2007. Could someone suggest a working syntax for Access 2007 please?

My latest attempt:

SELECT (t.id + ': ' + t.vendortitle) AS [ID / Vendor:],t.id,t.rev AS [Rev:],t.ver AS [Ver:],t.poprice AS [Price:] FROM tmptblqry_quotes AS t ORDER BY t.rev,t.ver,t.vendortitle

The challenge is that I really need to display the ID number and the Vendor name as multiple quotes could exist for one vendor, thus vendor name is not enough to identify the particular record.

 

[pbaldy]

Try

SELECT t.id & ": " & t.vendortitle AS [ID / Vendor:],...

 

[mdlueck]

LOL pbaldy!

I just came back to post the Rx I finally discovered:

SELECT t.id & ' / ' & t.vendortitle AS [ID / Vendor:],t.id,t.rev AS [Rev:],t.ver AS [Ver:],t.poprice AS [Price:] FROM tmptblqry_quotes AS t ORDER BY t.rev,t.ver,t.vendortitle

Thank you much!

 

[pbaldy]

No problemo!