Bring First and Last Names fields into one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I take a last name and a first name field and make them into one field?

I no you need to concatinate them into a query field but how do you do it?

Thanks
 
TKM said:
How do I take a last name and a first name field and make them into one field?

I no you need to concatinate them into a query field but how do you do it?

Thanks
Click to expand...


in the query field enter the expression:

lastName & ", " & firstName
 
Back
Top