If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Concatenate 2 fields into one via a query
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? -- GD |
#2
|
|||
|
|||
Concatenate 2 fields into one via a query
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 GD wrote: 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? |
Thread Tools | |
Display Modes | |
|
|