Concatenate 2 fields into one via a query

  • Thread starter Thread starter GD
  • Start date Start date
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?
 
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
 
Back
Top