Ho to use "IF" for different calcs in Reports

A

aprotin

I want to do one of two calculations ion a single report line in acces based
on what value is in a sataus code field.
 
K

KARL DEWEY

If the status is 'Xyz' then it will do Formula_1, otherwise it will do
Formula_2.
My_Calulation: IIF([Status] = "Xyz", Formula_1, Formula_2)
 
Top