How to fetch a record where column condition value is in between the values of two records

How to fetch a record where column condition value is in between the values of two records

 Hi,

Example Table Pricebook:

Weight    Price

0.5        100

1.0        200

1.5        250


I have another form where the user enters the item required and the weight as 0.8.

How do I search through the records to obtain the record with the higher weight than the user input value. i.e. in above case it is the record with weight as 1.0

A solution to this will be greatly appreciated.

Thanks!!!