select min([price]) FROM myTable WHERE qty> myqty
EDIT: I misread your post the first time.
if you want to do this in queries you may need a custom function to look up the number of records above a quantity first
i.e. in your query have something like
Code:
Public Function MAXVAL (iItemID as long, qty as long)
MAXVAL = dmax("[QuantityField]", "tblTableName", "[PK_Field] = " & iitemid)
if maxval > qty then maxval = qty
end function
then in your query you could have a formula like
select min(Price) from mytable where qty >= maxval(ID, myqty)