simple report question (why am I brain dead?) (1 Viewer)

madEG

Registered User.
Local time
Today, 07:29
Joined
Jan 26, 2007
Messages
309
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.
 

madEG

Registered User.
Local time
Today, 07:29
Joined
Jan 26, 2007
Messages
309
Arrrg! I ended up adding the grand total sum() to the report footer - and it works. Why was that so painful? :)

Thanks anyway...
 

Users who are viewing this thread

Top Bottom