embedded sql statement

  • Thread starter Thread starter george
  • Start date Start date
G

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
 
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
 
Back
Top