D David Plotts Aug 7, 2006 #1 I currently have 2 fields, First_Name and Last_Name. How do I merge them in a query into one field? Thanks
I currently have 2 fields, First_Name and Last_Name. How do I merge them in a query into one field? Thanks
D Duane Hookom Aug 7, 2006 #2 Create a new column in your query: FullName: First_Name & " " & Last_Name
G guido via AccessMonster.com Aug 7, 2006 #3 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.
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.
