Problem using "Iif"

  • Thread starter Thread starter Box666
  • Start date Start date
B

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
 
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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XP Backup Lacks 98 MSBACKUP Features 6
Limits of IIF? 4
IIf statement in query, Null value change to "0" 2
help with expression to display customer details 2
Access Building a IIF expression in Access 0
How do I use the IIF expression 5
IIf statements 3
Access Query problem 1

Back
Top