IFF Statements Excel to Access

[chan069]

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

[chan069]

switch([Au]>0.95 AND[As]<1.0 AND[K]<1.0 AND[S]<0.1,"SHG",
[Au]>0.85 AND[As]<0.8 AND[K]<0.95 AND[S]<0.2),"HG")....................................... .