How to query results if a price is greater than a sell price?

[anoble1]

I have ran into a pickle. I have data where I only want to show results where the actual sell price is greater or equal to a list price in the system. In other words I want to show only instances where you sold it for more than the system has in this List field.

How do I do that?
I have 2 columns of Data. List Price and Sell Price. Do I somehow use some criteria or combine a formula in the "Field"?
Would like to say something like

IF SELL >= List Price then Show the data else do not show data if you sold under List

Help?

[anoble1]

How about that. Tied something new for me.

>=[QS36F_PARTMAST]![PM_LIST]

Worked

I put this in the Criteria section of the query in Access.

[NeoPa]

The simple answer is to include criteria (WHERE clause) along the lines of :

WHERE ([SellPrice]>=[ListPrice])