Hi everyone. 95% of my working time I use Excel (never Access) but I was advised to shift to Access for a database. I copied the original excel file to Access but came up with problems on a formula. The excel formula is:
=IF(SEX="","",IF(OR(SEX={"CHURCH","SCHOOL","GOVERN MENT"}),"EXEMPT",IF(AND([@[Classification of Property]]="Residential Building",[@[Assessed Value
Imp.]]=0),"EXEMPT",IF(Year_1=2020,"CURRENT","DELINQUENT" ))))
When I copied this to Access, it says AND and OR are invalid syntax. How do I edit this to make it valid? Thank you.