I need to SUM the detail section in the Page footer.... please help!

K

Kelvin Beaton

I have a text box with the formula "=Sum([UnitPrice])+[ShippingCost]" and it
works fine in the Report Footer, but I really want it in the Page Footer.

[ShippingCost] is in the Page Footer
[UnitPrice] is in the Detail

Using MS Access 2003

What does it take to make this work in the Page Footer?

Thanks

Kelvin
 
A

Al Campagna

Kelvin,
Please Google Group search on
"public.access" page footer calculation
You'll find many solutions listed there.
 
F

fredg

I have a text box with the formula "=Sum([UnitPrice])+[ShippingCost]" and it
works fine in the Report Footer, but I really want it in the Page Footer.

[ShippingCost] is in the Page Footer
[UnitPrice] is in the Detail

Using MS Access 2003

What does it take to make this work in the Page Footer?

Thanks

Kelvin
Click to expand...

See Microsoft KnowledgeBase article:
132017 "How to sum a column of numbers in a report by page"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A03 - count in report footer gives me #Error? 0
Control detail section height size in Ac2007 2
Running Sum 13
Sum unique entries in report footer 2
Positioning Group Footer at then end of the Detail section 3
Summing in a group footer 5
Summing in a Report Footer 7
page header on second page of invoice. 3

Top