If then AND statements in access

[Sarah]

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

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

How would I write this in access?

 

[Sarah]

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

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

How would I write this in access?

Oops - This is what the statement is..

 

[Jerry Whittle]

Well there aren't any cells like B2 in Access. We would need the field names.

Also it would help if you showed us some sample data and what you would like
the result to look like.

 

[Clifford Bass]

Hi Sarah,

This would be an equivalent:

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

Or this:

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

Clifford Bass