field combination

[Guest]

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

 

[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
..

 

[Carl Rapson]

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

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

Carl Rapson