Footer and totals (2003)

Topic

New Reply

Today is not my day to be working in Access…..

I have a report with 2 footers with totals and a report footer with grand totals. The first footer happens when there is a change in audit #, it total the number of records and amounts. It also totals if there is a Status of open and a date field is blank. =IIf([status]=”open” And IsNull([rebuttaldate]),1,0). This works great. I also have the fields running sum = over group.

My next footer happens when there is a change in Company (each company can have more than one audit). This is where my problem is…my totals are not working here.

My grand total footer is working as well…fields = running sum – over all.

How to I get my total by company to work??? I have created fields in my detail area to count and add the amount. Again for audit the field would have =IIf([status]=”open” And IsNull([rebuttaldate]),1,0) with runnin sum – over group and in my report footer =IIf([status]=”open” And IsNull([rebuttaldate]),1,0) with running sum = over all. all the fields are created in my detail area.

Help….

Reply | Quote

Replies

Try putting a text box in the group footer with control source

=Abs(Sum([Status]=”open” And IsNull([RebuttalDate])))

Reply | Quote

OK…that worked…now how would I write this to add the amounts

=IIf([status]=”open” And ([rebuttaldate]>[dateofletter]),[Reimbursement],0)

Reply | Quote

Try

=Abs(Sum(([status]="open" And ([rebuttaldate]>[dateofletter])*[Reimbursement])))

Reply | Quote

Hans,

I get a parameter message to enter Reimbursements. What I need is a formula to add the reimbursements amount for each company?
Again the way I have it works for the audit footer and report footer but not for the company footer.

Reply | Quote

Are you sure that the field name Reimbursement is spelled exactly as it is in the record source of the report?

Reply | Quote

OK…I get now a whole number such as it counting the recordings not adding the reimbursements amounts.

Reply | Quote

Could you post a stripped down copy of your database? See post 401925 for instructions.

Reply | Quote