Merge Name Fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Plotts - 07 Aug 2006 20:52 GMT

I currently have 2 fields, First_Name and Last_Name. How do I merge them in
a query into one field?

Thanks

Reply to this Message

Duane Hookom - 07 Aug 2006 21:00 GMT

Create a new column in your query:

FullName: First_Name & " " & Last_Name

Signature

Duane Hookom
MS Access MVP

>I currently have 2 fields, First_Name and Last_Name. How do I merge them
>in a query into one field?
>
> Thanks

Reply to this Message

guido - 07 Aug 2006 21:07 GMT

Something like this:
Emp_Name:[MY_TABLE]![First_Name] & " " & [MY_TABLE]![Last_Name]
You can use the expression builder to put the formula into the query field.

Reply to this Message