If then AND statements in access

  • Thread starter Thread starter Sarah
  • Start date Start date
S

Sarah

I am trying to convert this excel IF statement into access.

=IF(A2<-10,"OK",IF(AND(A2<-5,B2="Y"),"OK","Not OK"))


How would I write this in access?
 
=Iif(intVarA2<-10 OR (intVarA2<-5 And strVarB2="Y"),"OK","Not OK")

Do you still need to refer to the Excel cells or are you replacing with VBA
variables?
 

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

If then AND statements in access 3
IIF statement to compare two fields. 3
Calculating Dates, PlEASE HELP! THANKS! 6
Calculating Dates 4
Comparing 2 text cells in an if statement 3
HELP! AND / OR criteria 4
IF Statement 3
Excel DateDif - why does 2007 seem different? 3

Back
Top