melodyF
04-23-2002, 01:08 PM
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.