Please Help - Need to finish this project

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
"John W. Vinson" wrote: 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







On Wed, 9 Apr 2008 17:37:01 -0700, teelee
wrote:

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?

Teelee, bear in mind: You can see your database. You know your fieldnames. You
can edit your expressions.

Clif, Arvin and I cannot. We're volunteers, donating our time on these
newsgroups; we're not Microsoft tech support, and we're not being paid to give
you complete solutions.

You will need to UNDERSTAND what the suggested code does, and if it applies to
your situation, use it; if not, adapt it; if you can't figure out how to adapt
it, you need to post enough information (what your fieldnames are, what
expression you used, what result you wanted, and what result you got) that
someone could help.
--

John W. Vinson [MVP]

On Apr 9, 7:37*pm, teelee wrote:
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.

--
Clif