combind and rename

P

Pierre

I would like to combine to table name in a Query. I have encountered an
error trying to build this. Could someone please assist me in getting this
right? This is what I have tried.
(error msg: Syntax error (missing operator) in query expression ‘[Full
Name]=[All info].[GivenName] & “, “ &’.)


In the SQL view of a query I ha
--

FullName=[All info].[SurName] & ", " & [All info].[GivenName]

intent is to have a Column named Full Name with results being
"LastName, FirstName"

Work is sometimes hard....but someone has to do it.
 
F

fredg

I would like to combine to table name in a Query. I have encountered an
error trying to build this. Could someone please assist me in getting this
right? This is what I have tried.
(error msg: Syntax error (missing operator) in query expression ¡¥[Full
Name]=[All info].[GivenName] & ¡§, ¡§ &¡¦.)

In the SQL view of a query I ha

FullName:[SurName] & ", " & [GivenName]

Note: You do not need to use the table name [All info] unless your
query includes more than one table with [SurName] and [GivenName]
fields.
 
P

Pierre

ty - I see the equal sign was killin me.
--
Work is sometimes hard....but someone has to do it.


fredg said:
I would like to combine to table name in a Query. I have encountered an
error trying to build this. Could someone please assist me in getting this
right? This is what I have tried.
(error msg: Syntax error (missing operator) in query expression ‘[Full
Name]=[All info].[GivenName] & “, “ &’.)

In the SQL view of a query I ha

FullName:[SurName] & ", " & [GivenName]

Note: You do not need to use the table name [All info] unless your
query includes more than one table with [SurName] and [GivenName]
fields.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top