Crystal Reports Return only one value

Message

   Hello,

I'm building a report on pricing for our products.

We have price breaks, which is screwing me up.

I only want the price that matches (or less than) the qty break.

the first qty field is {PTORDER_REL.REL_QUAN}

the qty break field is {ARINVT_BREAKS.QUAN}

the price that is attached to the qty break field is {ARINVT_BREAKS.QPRICE}

So let's say the qty breaks ({ARINVT_BREAKS.QUAN}) are:

qty 100  --> $1

qty 1000 --> $0.75

qty 5000 --> $0.50

If my PTORDER QUAN is 2500, I want the price field to only return $0.75 (vs listing all three prices causing duplicates) because it's more than 1000 but still less than 5000.

I hope my question makes sense. if not, I will answer any questions arise from this.

But I really need help  