search within range

[Guest]

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

 

[Van T. Dinh]

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

 

[Larry Daugherty]

In Access Help find BETWEEN.

HTH