Trying to figure out a formula

If Me.txtGross is 566.60 and txtMultiplier is 7.00% (datatype = number, double, percent, 2) what is the formula to come up with an answer of 526.94 ?

The human understandable (at least for me) is 566.60 x 93% but I can't figure out how to write the control source for the answer field.
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
You could also do this:

YourInputValue - (YourInputValue X (YourMultiplier/100))

566.60 - (566.60 x (.7/100)) = 526.938
Ferruccio AccalaiSenior developer, analyst and customer assistance Commented:
It should be
that is
(566.60/100)*(100-7) = 5.666*97 = 526.938
Gustav BrockConnect With a Mentor CIOCommented:
The direct method will be:

Me!txtNetto.Value = Me!txtGross.Value * (1 - Me!txtMultiplier.Value)

Open in new window

Or, for the rounded value:

Me!txtNetto.Value = CCur(Format(Me!txtGross.Value * (1 - Me!txtMultiplier.Value), "0.00"))

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.