Gday.
I have a databse Im trying to work on. It has a series of boxes that depending on various inputs provides a overall total.
I want to add a tick box named [DDT] and a field for its calculation [CalcDDT], on "true" I want the [CalcDDT] to display a number (say 20.. but any number really). Which I can accomplish using " iif" but because of the other fields it will not allow the total calculation when it is "false".
Ive had a crack at and/ or, but obviously missing something.
So what I am trying to do is have [CalcDDT] = 20 on [DDT] true and =0 on [DDT] false.
Any idea on how I can accomplish this please?
Thanks in advance