Concatenate (combine two fields into one)?

[jmlbones]

I have a Contacts table that has a First Name field and a Last Name field. I eventually want to export data into an Excel spreadsheet in a single name field. Is there a way I can do this by either adding a field to the existing table, creating a new table, or just combining them when I send the data to Excel? Thanks.

 

[Guest_imported]

Hi,

You can concatenate them in a standard "select" query. Then export that into Excel.

Example:

Name:[First]&" "&[Last]
or
Name:[Last]&", "[First]

It is a good idea to include a space between the quotes to avoid the names literally running into each other. Keep in mind that Excel works similar to that of a database. You can not sort on a last name field if you do not have a last name field. This is true in Excel as it is in Access.

Nevertheless, hope this helps.

 

[jmlbones]

I will give it a try. Thank you.