What is the process for combining fields in access?

Answer by  Nelson39 (58)

The easiest way is to press the SQL button when working in the Design View of a query or view. You will need to type into the area where the code is. For example: SELECT FirstName, LastName, FirstName + " " + LastName AS FullName FROM Customers

Answer by  rhelt (461)

The way I would accomplish this is to create an append quesry. In the query setup box, pull both fields that you wish to combine. In the third field, combine the two by typing [FieldName1] & [FieldName2]

Answer by  andrew10 (27)

Combining fields in Microsoft Access is called concatenation. To do this, you need to use the concatenation operator, which is the ampersand. For instance, to concatenate a field named City with a field named State, you would write "[City] & [State]" (without the quotation marks)

Answer by  Jenny25 (939)

To combine fields, it's simply a matter of merging them all together. You can access the merge button underneath the edit section for the MS Access Program. You select all of the fields that you want to be merged together. With these highlighted, go to edit and then click the merge button.

Answer by  vijayparttimejob (2254)

Join two or more fields (columns) into one in Microsoft Access. A wizard guides you through the process of selecting fields (in a table) to be merged. The values in the selected fields will be combined and put into a new field of your choice.