Hello,
I have a simple report that is based off a query that groups off a department code, and then sums the number of pc's in the dept.
So, the records come back in pairs...
Dept1, 4 PCs
Dept2, 6 PCs
Dept3, 10 PCs
Now the brain dead part:
How do I get a grand total? In this case I'd like 20 PCs to show on the bottom of the last page of the report.
I tried adding a text box with =sum(NumberOfPCs) in the footer for the grouped department field, but then the running total repeats for each department. e.g.
Dept1, 4 PCs
TOTAL: 4 PCS
Dept2, 6 PCs
TOTAL: 10 PCS
Dept3, 10 PCs
TOTAL: 20 PCS
How do I make this work without repeating the running total for every new group/department?
Desperate, I added the total text box to the page footer, but I get an error.
Can someone give me a push? Ugh. :banghead:
Thanks,
-Matt G.
I have a simple report that is based off a query that groups off a department code, and then sums the number of pc's in the dept.
So, the records come back in pairs...
Dept1, 4 PCs
Dept2, 6 PCs
Dept3, 10 PCs
Now the brain dead part:
How do I get a grand total? In this case I'd like 20 PCs to show on the bottom of the last page of the report.
I tried adding a text box with =sum(NumberOfPCs) in the footer for the grouped department field, but then the running total repeats for each department. e.g.
Dept1, 4 PCs
TOTAL: 4 PCS
Dept2, 6 PCs
TOTAL: 10 PCS
Dept3, 10 PCs
TOTAL: 20 PCS
How do I make this work without repeating the running total for every new group/department?
Desperate, I added the total text box to the page footer, but I get an error.
Can someone give me a push? Ugh. :banghead:
Thanks,
-Matt G.