Hi Access Gurus,
Im currently using Access as my database frontend.. i currently have a formula that decides what discount rate is being applied to an area but am somehow getting an error. Can someone please help:
Disc_Bill_To: IIf(Left([NOTES],2)="0%",0,IIf([Group_Level_1]="CONFEC",[Confectionery_Metro],IIf([Group_Level_1]="GUM",[Gum_Metro],IIf([Group_Level_1]="SNACKS",[Snack],
IIf([Group_Level_1]="Grocery",[Grocery_Metro],IIf([Group_Level_1]="BISCUITS",[Biscuits],IIf([dbo_STD_APL_ITEM]![BILL_TO_ID]=178000 and [Group_Level_1]="BEVERAGES",[BEVERAGES_Metro],
IIf([dbo_STD_APL_ITEM]![BILL_TO_ID]=210000,-0.235,IIf([dbo_STD_APL_ITEM]![BILL_TO_ID]=640000,-0.11732,IIf([dbo_STD_APL_ITEM]![BILL_TO_ID]=740000,-0.1111,"0")))))))))