I have an access 2007 application that has a person table, with last_name, first_name attributes. I would like to build a query where I can combine last_name and first_name, and represent the combined fields as one field "name". I have tried the following:
name:last_name & ", " & first_name
but I get syntax errors from SQL.
Is there a way to do this?
Thanks in advance for your help.