Concatenate 2 fields into one via a query

G

GD

I'm fairly new to Access and have limited knowledge of functions. First,
does anyone know of any online reference guide that might help me identify
the functions and (especially) what they do?

Second, I'm trying to concatenate two fields into one in a query. I've
tried using a simple

=[Field1] & " " & [Field2]

but that only causes the query to come back with no results at all. Both
fields are formatted as text, and I know that makes a difference. Can
somebody give me the exact expression I need to use?
 
J

John Spencer

Drop the Equals sign in the query.

Field: CombinedFieldName: [Field1] & " " & [Field2]

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 

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

Similar Threads

adding fields in query 2
concatenate 2 fields and add new field to table Update query 5
Consolidating multiple records into one record 0
Merge fields on a query table 1
How to CONCATENATE >50 fields in Excel table into SQL Insert State 3
Concatenate two fields and then make a lookup box 2
IIF Function Within A Query 8
Concatenating fields in a query 3

Top