Please Help - Need to finish this project

[teelee]

Ok my field names are as followed: PlanOrderID, Plan Name, Payment Method,
Customer Name, Date Plan Sold, Cost Of Plans, Eplan Charge, Web Charge,
Direct Bill, TPM Charge, AuthNEtCharge, and Total Revenue
: Now what I want to happen is in the form you would
enter the cost of plans, the payment method charge which would be WebCharge,
EPaln Charge, or Direct Bill. Then I would like this to total in the field
name Total Revenue in my form.
The expressions I've been using Total:
IIf([TotalRevenue]='N',[CostofPlans],[WebCharge]) When I enter this
expression I get only the WebCharge

With this expression:When I enter this one I'm getting the same thing above
Total:
IIf([TotalRevenue]='N',([CostofPlans]-[EPlanCharge]),[WebCharge])

When I enter this one I'm getting the WebCharge minus the TPM Charge only
Total:
IIf([TotalRevenue]='N',([CostofPlans]-[EPlanCharge]),([WebCharge]-[TPMCharge]))

So you see what's happening: I need it to total what information that I
enter for each Plan that is sold. If a Plan was sold by EPlan then I need it
to total this way: CostofPlan minus the WebCharge minus the TPM Charge minus
the AuthNetCharge.

And if the plan was purchased by EPlan Charge I need the total to say
WebCharge minus TPM Charge minus AuthNetCharge.

And if was purchased by Direct Bill then in the total field that's what
would be there. What I had entered into the form as the amount of the direct
bill. Any help is very much appreciated, I'm at the last point on my project
and I really need to finish it soon.

Thanks in advance

 

[Clif McIrvin]

The expressions that you sent I had copied and pasted into the Query. So do I
need to build these expressions or copy and paste the expressions that you
sent previous?

Thanks

Teelee, what I was asking you to do is to copy and paste YOUR
expressions into your posts here so that we can see exactly what you
are working with, not the other way around.

See John Vinson's excellent post this morning for more explanation.