I can't get a total on my form.

[jrabenhorst]

Hey everyone. So here's my newest problem. I'm building a database for an insurance company and I'm having some trouble getting a calculation to show up correctly on my form. I have two values... a total funeral bill, and a total amount filed. First I have to compare these two values to get the correct amount to discount for the insurance company. I'm using this formula in a footer of the form to calculate the discount.

=IIf([TotalFuneralBill]>Sum([TotalAmountFiled]),(Sum([TotalAmountFiled])),[TotalFuneralBill])

It's working fine, but I can't seem to get a sum of the values this expression creates. Everytime I try something in the report footer, I get a message about aggregate expressions. Does anyone have any ideas about how I can get the total I need? Thanks

 

[Pampers]

It's working fine, but I can't seem to get a sum of the values this expression creates. Everytime I try something in the report footer

I dont understand the problem. You calculate totals in a form footer. Then you make a report, and in that report you want to total the form totals?



Pampers
Just let it go...

 

[jrabenhorst]

I have the formula above in a text box in my report, but this formula creates this number for each set of policies per person. Since each report includes many people, the formula creates a number for each person, I need a sum of all those numbers. But I also need each individual number to appear on the report. Does this clear things up?