Problem with IIf statement

[melodyF]

I have a select query with a calculated field, Potential Payout: ([Total Points]-50)/(200-50)*0.12. I have other fields called Actual Payout and Disqualifier in the query. My question is how do I get the Actual Payout field to = 0, if the disqualifer field is not empty.

 

[David R]

Iif([Disqualifier] Is Not Null, 0,[WhateverTheCalculationIsForActualPayout])