combind and rename

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pierre - 21 Apr 2008 17:04 GMT

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

Signature

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.

Reply to this Message

fredg - 21 Apr 2008 17:25 GMT

> 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
[quoted text clipped - 3 lines]
>
> 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.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message

Pierre - 21 Apr 2008 19:30 GMT

ty - I see the equal sign was killin me.

Signature

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
[quoted text clipped - 9 lines]
> query includes more than one table with [SurName] and [GivenName]
> fields.

Reply to this Message