Home » Posts tagged "calculate in a query"

Tag Archives: calculate in a query

Structuring Queries In Access 2007

People prefer to keep complex data sets in databases rather than in flat files because data can be found and grouped more precisely when it is stored in a database. The ability to draw data out of a database depends upon the ability to structure queries, or requests that define specific records. Structuring queries in Access 2007 is relatively easy because Access is designed to handle many different types of operators. An operator is a special symbol or reserved word […]

Tags: , , , , , , , ,

Microsoft Access Query Formulas Combining Fields, Calculation

Microsoft Access

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 […]

Tags: , , , , , , , ,