Merge Name Fields

[David Plotts]

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

Thanks

 

[Duane Hookom]

Create a new column in your query:

FullName: First_Name & " " & Last_Name

 

[guido via AccessMonster.com]

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.