IF(AND) Formulas for Access

[harvella]

Hi,

I'm really hoping somebody can help me out with this problem. I'm starting to learn access and converting clunky Excel files over. I've figured a lot out but I'm having trouble with this one.



I need to insert a calculated field where there are two columns (% TY and % LY) and return a Yes or No depending on whether they fall between 25% and 90%.

This is the Excel formula =IF(AND(% LY>".25",% LY<.90)*AND(% TY>.25,% TY<.90),"Y","N")
Side note: I didn't write this, it was existing in a file when I got it.

Any help would be so very much appreciated. I can't find anything online and I'm pretty sure it's because I don't know how to ask the question correctly.

[pbaldy]

This should get you started:

=IIf(FieldName > .25 AND FieldName < .9, "Yes", "No")

[harvella]

THANK YOU, THANK YOU, THANK YOU!!!! This is a big help.

[pbaldy]

Happy to help and welcome to the site by the way!