Joining data in Access queries

When your Access query results need to look neat and tidy, you'll often want to join related pieces of data together that actually appear in separate fields of the file. For example if you have a list of first names and last names in separate fields (as you should), you can still view them in a single column in your query results.

To do this, join the data in the query data sheet, for example this will join the data from the FirstName and LastName fields and display it as a proper name in the query results:

FirstName & " " & LastName