search within range

J

john

can someone show me how to create a query to search within a range. e.g. i
want it to ask for a number and then i want it to show numbers in a table
between the weight typed in + 2 and the weight typed in -2

thnx in adv
 
V

Van T. Dinh

SELECT *
FROM [YourTable]
WHERE [YourTable].[Weight]
BETWEEN ([Enter Weight:] - 2.0) AND ([Enter Weight:] + 2.0)
 
Top