November 29, 200124 yr Newbies I have created an order form we fill in while our customer is on the phone with us. We enter the Product ID and auto enter the description. We offer quantity discounts, for example; 1- 12, 13 - 24, 25 - 50, 51 - 100. How can I get the quantity discount price to be automatically entered based on the quantity we enter in the quantity field? Thank you in advance for your help. Gary
December 7, 200124 yr Newbies Gary this is a simple use of a case statement calc. Define a field for Discount as: Case ( Quantity 1 and Quantity 12, "0", Quantity 13 and Quantity 24, ".03", Quantity 25 and Qantity 49, ".05", etc... ) [ December 07, 2001: Message edited by: TheGuardian ]
Create an account or sign in to comment