ema
10-31-2000, 12:13 PM
How can I have a sum function on a form default or not go below zero
|
View Full Version : Calculating totals ema 10-31-2000, 12:13 PM How can I have a sum function on a form default or not go below zero chrismcbride 10-31-2000, 04:55 PM Your answer is the IIF function. The basic syntax of the IIF is... IIF(Criteria, value if true, value if false) So IIF(([price]*[ordered]) > 0, [price]*[ordered], 0) Check help files for more details Chris ema 11-01-2000, 06:32 AM Thanks Chris that was just what I was looking for! |