Home » Posts tagged "Expression Builder"

Tag Archives: Expression Builder

Microsoft Access Reports – Passing Totals From A Subreport Into The Main Report

Microsoft Access

Working with Microsoft Access Reports can be time consuming and fiddly to master and one of the common challenges is correctly writing calculated expressions between main reports and their embedded sub-reports. If you are not familiar with writing expressions, then I suggest you start with the built in Expression Builder utility which will navigate and build the correct references. With the Expression Builder, users can create a hierarchal reference if loaded via the main report design with a sub-report included […]

Tags: , , , , ,

Microsoft Access IIF Function in a Query

This video tutorial is clear and simple to follow and explains the IIF function well (in it’s simplest form). Users who are normally familiar with Microsoft Excel’s IIF function will be able to relate to this function as it is the same! The only aspect you will need to know of course is how to create a calculation in a query which is demonstrated quickly in this video but if want to know more about how to calculate in a […]

Tags: , , , , , , , ,

Microsoft Access Databases – Learning the Fundamentals

Microsoft Access Database Tutorial

The Access database application provides a rich set of powerful tools ranging from a simple database design model to the multi-user network version using Access’s administrative tools at all levels which include the Relationship Window, Database Splitter, Linked Manager Tool and Access Security module to name but a few. If you have wondered where you start to learn access database then the quickest and simplest way, then welcome as I will step you through and guide you to learn access […]

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: , , , , , , , ,