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: access reports and subreports, calculating totals in ms access reports, Expression Builder, microsoft access reports, MS Access, working with subreports