Query - How can you string to fields together

  • Thread starter Thread starter OceanBreeze
  • Start date Start date
O

OceanBreeze

I have crated a parameter query where I have a last name field and a first
name field from the same table, and want them strung together to be shown
like this Doe, John.

Does anyone know how to accomplish this?
 
In query design view enter this is an empty field "block":
FullName: [Last Name] & ", " & [First Name]

In SQL view
SELECT [Last Name] & ", " & [First Name] as FullName
FROM SomeTable


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

extract 3 numbers from a string 0
Multiple Field Search using a query. 3
dynamic calculated field in query 3
#Error 1
string two columns together and use the string in another qry 4
query on date 1
Split data in field on character return 0
How to assign table name to be value of a field in a UNION query? 2

Back
Top