Problem using "Iif"

[Box666]

I am using the following to generate a select query

NewSel:IIf(([crdw] Or [selcal])=" ";"
";IIf([crdw]>=[SelCal];[crdw];[SelCal]))

also tried

NewSel:IIf(IsNull([crdw] Or [selcal]);"
";IIf([crdw]>=[SelCal];[crdw];[SelCal]))

it gives a #Error answer. In the above [crdw] is a table field but
[SelCal] is a calculated field.

It does not seem to be recognising the OR statement, how is the best
way to resolve this please.


Bob

 

[Brendan Reynolds]

You need to provide the complete conditional expression on either side of
the 'Or', e.g. ...

IIf(([drdw] = " " Or [selcal] = " "

.... and ...

IIf(IsNull([crdw]) Or IsNull([selcal])