If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Textbox Calculation is correct BUT still have problems
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? -- Jan |
#2
|
|||
|
|||
Textbox Calculation is correct BUT still have problems
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? -- Duane Hookom Microsoft Access MVP "Jan" wrote: 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? -- Jan |
Thread Tools | |
Display Modes | |
|
|