Query Syntax

[Rjc8513]

Can someone help me figure out the correct syntax for the following?

dbs.CreateQueryDef "QueryName", _
"SELECT [Last Name]'" & ", " & " [First Name]" ...

I'm trying to concatenate Last Name followed by a comma and First Name.

Thanks.

 

[mwolf00]

SELECT [Last Name] & ", " & [First Name] as [Full Name] FROM myTable Get the Best Answers! faq333-2924
"A witty saying proves nothing." - Voltaire
mikewolf@tst-us.com