Software

Ask something
Discussion Locked

Access Reports in XP

0 helpful
4 replies

by lf king

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a table with four columns in which I've listed donations made by individuals. Each entry has a batch Number assigned. I've run a query on the table to get the total for each heading (Donations, Luminaries, Team Regisitration, Corporate Sponsor) and each of those sum in the query. I developed a report to cover these and get the information to come over.
What I can't get is a formula that will total the four columns together as a grand total.
Closet I've got is a #error. Most time it display nothing.
Formula I entered is =[Donation]+[Luminaries]+[Team Registration]+[Corporate Sponsor]

Any suggestions

4 replies

by techrep

Assume that you're displaying each total field in a text box with the following names: TxtDonation, TxtLuminaries, TxtRegistration, TxtSponsor. Then use the Report object to total these text boxes like this:

=(Report.TxtDonation + Report.TxtLuminaries + Report.TxtRegistration + Report.TxtSponsor)

Put that statement in the controlsource property for the textbox displaying the column totals.

by alpha48

The formula is almost correct. It should be =sum([fieldname]+[fieldmane]+[fieldmane]+[fieldname]), notice the ()placement...but most importantly it must be located in the report footer. Go to VIEW and pick that option and place the sum formula in a text box. The Northwind example database reports in design view will help.

Regards.

This discussion is closed to new replies.