Merge one or more fields

[muralikreddy]

Hi,

I want to create an expression in a query, which is a combination of one or more fields in a table. e.g., Concatenate function in excel. Is there any such function in access. Please help me.

Thanks & Regards

 

[boblarson]

In FIELD in the query, put the name you want for the expression, followed by a colon and then use the Ampersand (&) to concatenate.

Example:

CustomerName:FirstName & " " & LastName

As long as there is only one field named FirstName and LastName in your tables that you are including in the query, you only need to reference the field name. If it has the same name in multiple tables, you will need to preface it with the table name and then a period. If the field names have spaces you will need to put square brackets around it.

 

[muralikreddy]

Thanks a lot Bob