field combination

B

bladelock

I have two fields in my database, last and first
I want to combine last+first with a comma and a space in between them
Example: Hanks, Tom

How do I write a query for this?

Thanks
 
J

John Spencer

In the query grid you would enter

Field: FullName: [Last] & ", " & [First]

In SQL that would look like

SELECT [Last] & ", " & [First] as FullName
FROM SomeTable

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
C

Carl Rapson

bladelock said:
I have two fields in my database, last and first
I want to combine last+first with a comma and a space in between them
Example: Hanks, Tom

How do I write a query for this?

Thanks
Click to expand...

SELECT ([last] & ", " & [first]) As fullname ...

Carl Rapson
 
Top