Newbies innoplas Posted November 29, 2001 Newbies Share Posted November 29, 2001 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 Link to comment Share on other sites More sharing options...
Newbies rpoelking Posted December 7, 2001 Newbies Share Posted December 7, 2001 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 ] Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8196 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now