There's no built-in way to generate a running total in your Access queries, but you can still get the job done if you set up your table correctly and build the right expression. Database expert ...

I've recently been rethinking the approach I took in solving the problem in Access with dynamic SQL. Most of the code was just strung together query logic mixed in with VB.