J
JohnLute
I know the following expression is a little wild but it's within the
character limit and as far as I can tell I haven't made any syntax errors
however when I try to execute it the "Expression is too complex" error
returns.
Have I done something wrong or have I pushed Access too far?
Thanks!!!
OFCapml: IIf([OFCapUOM]="fl.
oz.",[OFCap]*29.573529563,IIf([OFCapUOM]="pt.",[OFCap]*473.176473,IIf([OFCapUOM]="qt.",[OFCap]*946.352946,IIf([OFCapUOM]="gal.",[OFCap]*3785.411784,IIf([OFCapUOM]="bbl.",[OFCap]*119240.471196,IIf([OFCapUOM]="cu.
in.",[OFCap]*16.387064,IIf([OFCapUOM]="cu.
ft.",[OFCap]*28316.846592,IIf([OFCapUOM]="cu.
yd.",[OFCap]*764554.857984,IIf([OFCapUOM]="µ",[OFCap]*0.001,IIf([OFCapUOM]="ml",[OFCap]*1,IIf([OFCapUOM]="cl",[OFCap]*10,IIf([OFCapUOM]="dl",[OFCap]*100,IIf([OFCapUOM]="l",[OFCap]*1000,IIf([OFCapUOM]="cu
mm",[OFCap]*0.001,IIf([OFCapUOM]="cu cm",[OFCap]*1,IIf([OFCapUOM]="cu
m",[OFCap]*1000000,IIf([OFCapUOM]="oz.",[OFCap]*28.349523125,IIf([OFCapUOM]="lb.",[OFCap]*453.59237,IIf([OFCapUOM]="T.",[OFCap]*907184.74,IIf([OFCapUOM]="mg",[OFCap]*0.001,IIf([OFCapUOM]="g",[OFCap]*1,IIf([OFCapUOM]="kg",[OFCap]*1000,IIf([OFCapUOM]="MT",[OFCap]*1000000)))))))))))))))))))))))
character limit and as far as I can tell I haven't made any syntax errors
however when I try to execute it the "Expression is too complex" error
returns.
Have I done something wrong or have I pushed Access too far?
Thanks!!!
OFCapml: IIf([OFCapUOM]="fl.
oz.",[OFCap]*29.573529563,IIf([OFCapUOM]="pt.",[OFCap]*473.176473,IIf([OFCapUOM]="qt.",[OFCap]*946.352946,IIf([OFCapUOM]="gal.",[OFCap]*3785.411784,IIf([OFCapUOM]="bbl.",[OFCap]*119240.471196,IIf([OFCapUOM]="cu.
in.",[OFCap]*16.387064,IIf([OFCapUOM]="cu.
ft.",[OFCap]*28316.846592,IIf([OFCapUOM]="cu.
yd.",[OFCap]*764554.857984,IIf([OFCapUOM]="µ",[OFCap]*0.001,IIf([OFCapUOM]="ml",[OFCap]*1,IIf([OFCapUOM]="cl",[OFCap]*10,IIf([OFCapUOM]="dl",[OFCap]*100,IIf([OFCapUOM]="l",[OFCap]*1000,IIf([OFCapUOM]="cu
mm",[OFCap]*0.001,IIf([OFCapUOM]="cu cm",[OFCap]*1,IIf([OFCapUOM]="cu
m",[OFCap]*1000000,IIf([OFCapUOM]="oz.",[OFCap]*28.349523125,IIf([OFCapUOM]="lb.",[OFCap]*453.59237,IIf([OFCapUOM]="T.",[OFCap]*907184.74,IIf([OFCapUOM]="mg",[OFCap]*0.001,IIf([OFCapUOM]="g",[OFCap]*1,IIf([OFCapUOM]="kg",[OFCap]*1000,IIf([OFCapUOM]="MT",[OFCap]*1000000)))))))))))))))))))))))