Results 1 to 3 of 3
  1. #1
    jessesingh is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Apr 2016
    Posts
    1

    Angry Error in Formula -

    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")))))))))

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    could be anything - telling us what error you are getting (the description, not the number) would go a long way to enabling someone to help

  3. #3
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    You're missing closing bracket at the end.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. IIF Formula Error
    By phanikumarbs in forum Queries
    Replies: 3
    Last Post: 02-27-2014, 11:46 AM
  2. #Num! error in my formula
    By Eastbay2 in forum Access
    Replies: 2
    Last Post: 01-24-2013, 05:14 PM
  3. ERROR msg WHILE USING IIF FORMULA
    By CUCKOO in forum Access
    Replies: 9
    Last Post: 10-03-2012, 12:40 PM
  4. getting a #error from count(iif( formula
    By vickan240sx in forum Access
    Replies: 1
    Last Post: 09-21-2012, 08:34 PM
  5. Error in Formula
    By TheProfessorIII in forum Access
    Replies: 9
    Last Post: 03-21-2011, 05:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums