Concatenating fields in a query

[DV]

How can I concatenate 2 fields in a query. When creating a report I use the
following:

[Field1]&", "&[Field2]

When I try this in a query only Field1Value is returned.

 

[Rick B]

In a new column in your query, put something like the following...

NewName: [Field1]&", "&[Field2]

Where "NewName" is the name you will assign to the new column.

 

[Nick 'The database Guy']

Hi DV,

You seem to have the correct syntax, is the text box that you are
trying to display it in big enough?

Good luck,

Nick

 

[Nick 'The database Guy']

Rick,

Access always puts in a default label if there is not one inserted by
the user, such as Text45, or some equally discriptive title.

Nick

In a new column in your query, put something like the following...

NewName: [Field1]&", "&[Field2]

Where "NewName" is the name you will assign to the new column.


--
Rick B

How can I concatenate 2 fields in a query. When creating a report I use
the
following:

[Field1]&", "&[Field2]

When I try this in a query only Field1Value is returned.