simple report question (why am I brain dead?)

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.

simple report question (why am I brain dead?)