embedded sql statement

[george]

Hi,
I have this query:
SELECT [client_LName] & ", " & [client_FName] AS
CompleteName

if I want to embed it to a vba statement how do I deal
with the ", " part?

(ie I cannot write cboClients.RowSource = "(my sql
statement as is)"

Thanks, George

 

[Ron Weiner]

Try
strSql = "SELECT [client_LName] & ', ' & [client_FName] AS CompleteName"
Or
strSql = "SELECT [client_LName] & "", "" & [client_FName] AS
CompleteName"

Either will work. Then you can write;
cboClients.RowSource = strSql

Ron W