Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2015

    Unanswered: IIf function Not Returning Correct Calculation


    I'm trying to use Access to calculate some invoices, this involves the sale of individual items and bulk items. I want Access to calculate whether to charge customers the bulk price, or the standard price on orders automatically based on the quantity entered.

    For my "Actual Item Cost" field, I used the Iif statement:

    IIf([Quantity Purchased]>=[Bulk Minimum Quantity],[Bulk Price],[Standard Price])

    to try do this but the field only ever returns a value of 1.

    For the sake of the example, Quantity purchased is 16, bulk minimum quantity is 15, bulk price is $40, and standard price is $50. They are in my "invoice" table and bulk minimum order quantity, bulk price, and standard price are all look-up fields to my "products" table.

    I've searched as well as I can on the forum but can't find a similar situation. Any ideas?

    Thanks in advance.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    Without details of thr table / column designs, No
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts