excel 2003 query criteria field value help

hello can someone please help

i use a SAP like system at work that has a database i can run in excel using the mircosoft query.
i have a worksheet that looks at all the items that i have sold over the last 12months.

it shows
current stock qty
12 months sales
month by month break down
average over the last 12 months
min order qty
max order qty

what i would like to do is to have the query to filter a criteria based on where the average is less than the min order qty (high lighting that the min stock levels are to high)

average (field) less than min qty (field)

i know i could do a auto filter on excel but that okay for me but not for non excel users.
i hope this makes some sort of sense (it does in my head)

In a new column, I did a quick IF statement returning a 1 if avg was less than min (=IF(avg<min,1,""), then filtering on all cells with a "1" in them.

thank you for your help but i was hoping to be able to run this in the query
as the results run into the thousands