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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible to Combine reports to's to a single box? 0
Weekly Report 2
"Build" in Control Source greyed out 1
Command button does not pick the correct report. 7
Finding the right style field in VBA 0
Charts on a Report 4
Calculate the median value before a specified list 0
Need Help with a VBA subroutine 0

Top