If you wanted to calculate a running sum (or a cumulative total) for a report; this is simply set by using the correct ‘Running Sum‘ property for a selected control like a numeric bound field (text box) and all you need to do is decide whether this will be over a group or the whole report. However, this doesn’t exist in a query and to mimic the report feature to recreate running totals query in Microsoft Access, you will need to […]

Tags: access query properties, dsum function in ms access, how to create a query, MS Access, ms access queries, totals query in microsoft access