How to concatenate strings in access views with MSDE

[chingachgook]

I used to have tblUsers.Firstname & tblUsers.Lastname in a select come out as full name. But since I upsized to MSDE SQL server, these types of string concatenations don't work. Can anyone tell me how to do this?

A second option, or so I thought, was to define a textbox on my report as unbound. Then hide the firtname and lastname and with the report_open subroutine say
me.fullnamebox = me.firstname & " " & me.lastname

but it yells at me about fullnamebox not being defined.

 

[LonnieJohnson]

Have you tried using the plus sign (+) verses the ampersand ? ljprodev@yahoo.com
Professional Development
MS Access Applications