Usin Or with IF statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use the formula made in Excel and copying it to Access. In
Excel, the formula looks like This:
=IF(P1="O","HE",IF(O1="F","FLOAT",IF(OR(M1="",N1="",N1<TODAY()),"EXPIRED","Yes")))
How can I change it to Iff statement in Access Query (not in a form). I am
getting error in combining the OR part. Thanks.
Purnima
 
Try this: TargetField: IIF(FieldP="O","HE",IIF(FieldO="F","FLOAT",IIF(IsNull
(FieldM) Or (IsNull(FieldN)) Or (FieldN<Date()),"EXPIRED","Yes")))

HTH
 
Thank you very much. The code works perfectly. I learned a new thing today.
Thanks for your help.
purnima
 

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

Too many levels in the IF function? 12
How do I combine the 4 IF formulas into 1 formula 5
If Then Or Statement 3
checking data in two rows and change the data accordingly 11
If Then Or Statement 4
Validation Question 8
IF Statement 3
Attendance Tracking 1

Back
Top