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

concatenate 2 fields and add new field to table Update query 5
How to CONCATENATE >50 fields in Excel table into SQL Insert State 3
concatenate from query 1
IIF Function Within A Query 6
Concatenate two fields into one in same table 5
join 2 fields into one so user can search on new field 4
Combining Fields in a Query into Two Fields 3
Adding two fields from a crosstab query in a report 1

Top