### Title

quantity break price averages

### Post

I've tried to approach this in several ways without luck. Here's the dilema;

There are 5 different quantity fields and 5 corresponding but unrelated margin fields. I wanted to evaluate and average the margins with quantities of 1 to 10, 11 to 50, 51 to 100, etc.

or ideally when inputing a new quantity a calculation field which would give a suggested margin based on the customer code.

I know this is asking a lot.

And we need to know more about your system before we can suggest much.

There are 5 different quantity fields and 5 corresponding but unrelated margin fields.Does that mean that you have 10 fields, 5 for quantity and 5 for their corresponding margins?

What does a single record in this table represent? A single item in your Product table? A specific customer? Could there be more than 5 such pairs of fields? Can you provide a sample margin calculation and explain how it might be different for different quantities and customers?

or ideally when inputing a new quantity a calculation field which would give a suggested margin based on the customer codeWould this represent a 6th pair of such fields or an update to one of the 5 that you describe? Is this for one product for one customer? Or all products that customer might purchase? How does the identity of the customer affect the margin calculation? (Type of customer, past sales history, current order quantities, or ?...)