correct syntax

[Richard]

Hi

Would someone please help correct this syntax.

me.cmbco.rowsource= "SELECT ([firstname]+" ") & [lastname] AS Expr1 FROM
WBdata;"

Thanks in advance
Richard


--

 

[Dan Artuso]

Hi,
Try this:
me.cmbco.rowsource= "SELECT firstname & " " & lastname AS Fullname FROM WBdata"

 

[Van T. Dinh]

Try:

me.cmbco.rowsource= "SELECT ([firstname]+"" "") & [lastname] AS Expr1 FROM
WBdata;"

(as 1 line)

 

[Richard]

Thanks a lot to both of you. It works perfectly. Will creating a function
for the fullname slow down the query?

Thanks again

Richard

--

Try:

me.cmbco.rowsource= "SELECT ([firstname]+"" "") & [lastname] AS Expr1 FROM
WBdata;"

(as 1 line)

--
HTH
Van T. Dinh
MVP (Access)

Hi

Would someone please help correct this syntax.

me.cmbco.rowsource= "SELECT ([firstname]+" ") & [lastname] AS Expr1 FROM
WBdata;"

Thanks in advance
Richard

 

[Van T. Dinh]

Yes since JET database engine has to refer the function
back to Access VBA. However, unless the Table has tens of
thousands of Records, you probably won't know the
difference.

HTH
Van T. Dinh
MVP (Access)

 

[Richard]

Thanks a mil

Richard

--

Yes since JET database engine has to refer the function
back to Access VBA. However, unless the Table has tens of
thousands of Records, you probably won't know the
difference.

HTH
Van T. Dinh
MVP (Access)