IF Statement and Multiplication

[meinpsl]

Hi
I need help creating a calculated field. I'm not sure how to write the IF statement.
Calculated Field Name: Special_Rate
Data Field Name: phrearn_earn_code
Bascially....
If phrearn_earn_code = OT1, then I need to Multiply OT1 * .5 for a total.

Thanks

 

[KenHigg]

Do you plan on doing this in the underlying query on directly on the form?

 

[meinpsl]

IF statment and Mutiplication

Hi Ken
It's in a Query.
THANK YOU!

 

[Pat Hartman]

Select IIf(phrearn_earn_code = OT1, OT1 * .5, ?what do you want to do if they are not equal?) As Calc1, fldA, fldB, etc.
From YourTable;

You need to provide an expression for the false case of the IIf().

 

[meinpsl]

Query using If and Multiplication

Hi Pat
I just want to multiply OT1 *.5 if earn_code is = OT1. Ignore all other codes in earn_code

 

[Pat Hartman]

It doesn't work that way. You have to specify what you want or the calculated field will be null when OT1 <> earn_code.

 

[KenHigg]

IIf(phrearn_earn_code = OT1, OT1 * .5, OT1)

(But this would only seem to work if phrearn_earn_code and OT1 are numeric values...)
(Or did I miss something?)

 

[meinpsl]

Query Multiplication

Sorry I confused everyone.

I'm retrieving more then just that one field. Also, Total_pay, but based on the earn_code of OT1. I think Pat answered my question.

Thank you everyone.