D dbalargin Member Local time Today, 02:13 Joined Dec 31, 2002 Messages 39 Feb 6, 2003 #1 I have a query with the fields: First_Name and Last_Name. I want to create a field that is made up of both fields and call it Name. Thus, Name = First_Name + Last_Name
I have a query with the fields: First_Name and Last_Name. I want to create a field that is made up of both fields and call it Name. Thus, Name = First_Name + Last_Name
J Jon K Registered User. Local time Today, 07:13 Joined May 22, 2002 Messages 2,209 Feb 6, 2003 #2 Add this setting in a new column in the query grid:- Field: Name: First_Name & " " & Last_Name Show: check
Add this setting in a new column in the query grid:- Field: Name: First_Name & " " & Last_Name Show: check
D dbalargin Member Local time Today, 02:13 Joined Dec 31, 2002 Messages 39 Feb 6, 2003 #3 Works like a charm...Thanks!