Textbox Calculation is correct BUT still have problems

  • Thread starter Thread starter Jan
  • Start date Start date
J

Jan

I have a member report with
a Page Header specifying the member
a Member ID Header specifying the column details of member payment record
the details of payments with a "AmountPaid" field
a Member ID Footer specifying the summary of AmountPaid and whether the
member qualifies for additional funding or not by 1 textbox checking
with an IIF
statement:
=IIf([Sum Of AmountPaid]>=[Allowance],"YOU HAVE MET OR EXCEEDED
YOUR BENEFIT AMOUNT OF $2000.","You are eligible to receive benefit
assistance, your remaining benefit balance is: " & "$" &
[Remaining])

A MEMBER detail reports look like the following (not all members):

PdID UType UtilCo Applied Approved Paid ChkDt
Chk#
12 Elec AE 4/2/2009 4/6/2009 1119.05 4/7/2009 00096
83 Elec AE 5/13/2009 4/6/2009 409.40 5/15/2009
00469
99 Elec AE 7/29/2009 7/29/2009 408.22 7/29/2009 07380
279 Elec AE 7/29/2009 7/29/2009 63.33 7/29/2009 07380

The message I receive from the IIF statement is:
You are eligible to receive benefit assistance, your remaining benefit
balance is: $2.27373.

and I should receive the message:
YOU HAVE MET OR EXCEEDED YOUR BENEFIT AMOUNT OF $2000.

Not all members reports are this way, it's just a few of them that don't
calculate to $2000.

Any suggestions on how to fix this?
 
You haven't provided any information regarding
- where Allowance comes from
- how [Sum of AmountPaid] is calculated

Have you tried copying and pasting records from your record source into
Excel and testing the calcs?
 
Back
Top