tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities DigMinecraft
Share this page:

MS Access: Concatenate two fields in a query in Access 2003/XP/2000/97

See solution in other versions of Access:

Question: In Microsoft Access 2003/XP/2000/97, I have a database and I need to know how to concatenate two fields when creating a query. I need to be able to see these two concatenated fields in my query result set.

Answer: To concatenate two fields into a single field in your result set, open your query in design mode. Next enter your field names in the query window separated by the & symbol.

In the example below, we've decided to create a field in our query that is comprised of the field called FirstName in the Employees table, then a single space, and then the LastName field from the Employees table.

Access will automatically assigned a name for this field in the result set. In this example, it has named the new field Expr1.

Microsoft Access

You will probably want to overwrite the name from Expr1 to something more meaningful. We've renamed the field to Name as seen in the picture below.

Microsoft Access

Now when you run this query, your results should look as follows:

Microsoft Access

As you can see, there are two fields in our result set. The concatenated field that we called Name and the Title field from the Employees table.