View Full Version : Calculation in report


dantyler69
02-25-2005, 10:00 AM
Hi
I have a report in which i have a checkbox. If this checkbox is checked i want a textbox to display one calculation, if the textbox is unchecked i want it to display another calculation. Whats the easiest/fastest way of doing this??
cheers dan

Uncle Gizmo
02-25-2005, 12:18 PM
You would be far better of building a query to do this, then base your report on that query.

Rich
02-25-2005, 02:26 PM
=Iif([MyCheckbox],SomeCalc,SomeOtherCalc)