Microsoft Access Query Formulas Combining Fields, Calculation

Queries are the heart of any Access database and ms access 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.

As a Thank You for Visiting!

Claim your free eBook NOW

Enjoy 🙂

Kind regards,

Ben Beitler-“Your Access Database Expert!