Can't Figure Out How To Do This Calculation - PLEASE HELP!!

[Guest]

Hi all,

I've got Calculation #1 down...no problems there.

I need to base another calculation (#2) on Calculation #1.

Calculation #1 - PricePerUoM/QtyReceived (works like it's supposed to
Ex. - $10.75 divided by 6. Answer is $1.79.

(Price actually paid is $10.75 but if you multiply $1.79 by 6 it comes out
to $10.74.)

Calculation #2 - Needs to be the difference between the $10.75 and the
$10.74 (Adjustment).

Would I have to have another column to multiply $1.79 by 6, then use the
Adjustment column for the difference between the $10.75 and the $10.74?

Is there that would work without having to redo the table and form?

Thanks very much for your help.

Kathleen

 

[Pat Hartman\(MVP\)]

You can refer to another control name in a calculation:

txtCalc1 - txtCalc2

I strongly recommend that you use meaningful names for your controls. There
is no need for you or anyone else to suffer with code that looks like:
If Text45 <> Text 82 AND Text101 = Text14 Then
Text8 = "completed"
Else
Text8 = "I can't stand this any more"
End If

If you already have code behind poorly named controls, you'll need to move
it if you rename the controls. Access "looses" is when the controls are
renamed.