Tag Archives: Expression Builder

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

Microsoft Access Reports – Passing Totals From A Subreport Into The Main Report 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 … Continue reading

Posted in Microsoft Training, MS Access, Reports | Tagged , , , , | Leave a comment

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 simpliest form). Users who are normally familiar with Microsoft Excel’s IF function will be able to relate to this funtion as it is … Continue reading

Posted in MS Access, Queries, Utilities | Tagged , , , , , , , , | 5 Comments

Microsoft Access Databases – Learning the Fundamentals

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 … Continue reading

Posted in Database Theory, Forms, Macros, MS Access, Queries, Reports, Tables, Utilities | Tagged , , , , , , , , , | 23 Comments

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 … Continue reading

Posted in MS Access, Queries, Utilities | Tagged , , , , , , , , | 3 Comments