How do you "Concatenate" text fields in a query expression???

Hi,

Does anyone know how to concatenate text fields in an access query?
For example, if I have two fields - field1 and field2 I would like to be able to use something like Excel's function: =Concatenate([Field1],[field2]).

Please help.
Thank you,
Jen
jenica024Asked:
Who is Participating?
 
RDWaibelConnect With a Mentor Commented:
NewValue: [field1] & [field2]
0
 
chikenheadConnect With a Mentor Commented:
select field1 + filed2
from table3
0
 
mbizupConnect With a Mentor Commented:
Try this:
SELECT Field1, Field2, Field1 & field2 as CatField
FROM YOurTable
0
 
chikenheadCommented:
you may also wish to do something like this

Select field1 + ', ' + field2
from yourtablehere

This would add a comma and space between the fields    the & will also work instead of the +
0
 
jenica024Author Commented:
a BIG THANK YOU!
0
All Courses

From novice to tech pro — start learning today.