Hi. I'm a novice with Access, so please bear with me:
I've created a query that subtotals all the months (jan - dec) from a table. Now, I would like to add column in the same query that gives me the sum of all months. I tried building a formula, but I'm getting errors when I try to run.
Any thoughts?
Thanks.
I've created a query that subtotals all the months (jan - dec) from a table. Now, I would like to add column in the same query that gives me the sum of all months. I tried building a formula, but I'm getting errors when I try to run.
Any thoughts?
Thanks.