Ho to use "IF" for different calcs in Reports

  • Thread starter Thread starter aprotin
  • Start date Start date
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.
 
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)
 
Back
Top