IIF in report not working correctly

[kmclane]

I have a report which has a field that is conditional on the value of another field. If the field is less than $1000.00 I need to subtract the value from $1000.00 and post the difference, other wise post $0.00. It works fine when it is less than, but if it is greater than, it is still doing the subtraction instead of posting the $0.00. here is my code:

=IIf([SettlementReportPage2Paysys].[Report]![BuyRateTotal]>"$1000.00","$1000.00"-[SettlementReportPage2Paysys].[Report]![BuyRateTotal],"$0.00  ")

Any suggestions on where I'm off here would be great. Thanks, Ken

- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg

 

[kmclane]

Never mind. "<" works better than ">". Duh.

- If you are flammable and have legs, you are never blocking a fire exit.
Mitch Hedburg