A
Allison
I'm trying to run a Select query and have it update as a
report with grand summary totals in 4 fields. How do I
calculate the column totals below in a select query?
Here is an example of what I'm trying to do:
I want my report to look like this each time I open based
on the select query critiera:
OBLIG FY1 FY2 FY3 FY4
16,200 17,000 18,000 20,000 25,000
18,700 19,700 20,700 25,700 35,700
19,520 20,520 25,700 30,700 40,700
Grand Total: $54,420 57,220 64,400 76,400 101,400
report with grand summary totals in 4 fields. How do I
calculate the column totals below in a select query?
Here is an example of what I'm trying to do:
I want my report to look like this each time I open based
on the select query critiera:
OBLIG FY1 FY2 FY3 FY4
16,200 17,000 18,000 20,000 25,000
18,700 19,700 20,700 25,700 35,700
19,520 20,520 25,700 30,700 40,700
Grand Total: $54,420 57,220 64,400 76,400 101,400