Okay, so i am trying to compare two different fields related by a customer number but differentiated by another field. The layout looks something like this:

cust_no, consump, mxu_id
0000001,      13,     LF
0000002,      10,     LF
0000003,     117,     HF
0000004,      43,     LF
0000004,      60,     HF
0000005,      91,     LF
0000005,      70,     HF

Ideally, i would like the report to return only those values where consumption (consump) is identified as being High Flow (HF) AND where the high flow consumption is greater than the Low Flow Consumption (LF). In short, it should only return customer number 0000004.

Is there any way to do this?

I have a selection query that works great for listing anything with HF and LF since mxu_id can contain quite a few other things.

Good advice. Im not in the office today but i will implement it tomorrow.

The problem with the Next Consump > consump is that the High Flow does not always come after Low Flow so i cannot rely on that to consistently output my desired data.

...
DBlank, I love you.
Nah, JK. This is the first time ive had a chance to look at the issue in the past few days but DBlank's post looks promising. Thank you.