combind and rename

  • Thread starter Thread starter Pierre
  • Start date Start date
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.
 
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
Click to expand...

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.
 
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
Click to expand...

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.
Click to expand...
 
Back
Top