hello everyone.. i apologize if there have been other entries like this but i just had to this last minute thing and microsoft access and vb6 is killing me right now..

so i have a table with a "minimum", "maximum", and "amount" field all set to number data type, double, fixed, and 2 decimal places

in my program i have a textbox that contains a certain value.. once i click the button it is supposed to search the database for where the value on the textbox is in between the minimum and the maximum..

E.G.

minimum maximum amount
0.00 499.00 100.00
500.00 599.00 200.00
600.00 699.00 300.00

text1.text = 555.00

what is the most appropriate sql for this so i get the 200.00 amount needed
since 555.00 is in between 500.00 and 599.00

i am sooo looking forward to an answer.. thank you sooo much in advance to whoever helps out.