John,

I was afraid that people would not understand what I was talking about.  Here is some sample data.

Sale:

Item: GPH113

Price: 12.00

Price Matrix:

GPH113

Qty:>9        Price: 12.00

Qty:<9 and >24    Price: 11.00

Qty: <24...