Microsoft Access Query Formulas Combining Fields, Calculation

Queries are the heart of any Access database and this query is typically utilised especially when wanting to calculate.
A common type of calculation is known as ‘Concatenate’ which is demonstrated here with the ‘FirstName’ and ‘LastName’ fields.
Also, this query uses the common ‘nz’ function to deal with null to zero calculations.

Note the naming conventions for fields i.e. no spaces but spaces are acceptable for aliases.