Is it possible to rewrite the below formula for access?
=IIf(AND([Au]>0.95,[As]<1.0,[K]<1.0,[S]<0.1),"SHG",
IIf(AND([Au]>0.85,[As]<0.8,[K]<0.95,[S]<0.2),"HG",
IIf(AND([Au]>0.75,[As]<0.7,[K]<0.90,[S]<0.3),"MO",
IIf(AND([Au]>0.65,[As]<0.6,[K]<0.85,[S]<0.4),"DO",
IIf(AND([Au]>0.55,[As]<0.5,[K]<0.80,[S]<0.5),"DOA",
IIf(AND([Au]>0.45,[As]<0.4,[S]<0.60),"DOS",
IIf(AND([Au]>0.35,[As]<0.3,[K]<0.70,[S]<0.7),"LG",
IIf(AND([Au]>0.25,[As]<1.0,[K]<0.65,[S]<0.8),"BAS",
IIf(AND([Au]>0.15,[S]<0.90),"BA",
IIf(AND([S]>0.95),"BA_DO",
IIf(AND([Au]<0.05),"R"
)))))))))),"NA")
Regards,
Chan