user input query

[Guest]

Hi, my problem is this, i have a table with various fields, but for this
question it only uses 2 fields as criteria for it's search. the fields used
are suburb and size. i am using user input, so in my "criteria" box of the
query (in design view), it reads under suburb: ["Enter suburb"] and under
size ["Enter size"]. this works perfectly, but i need to tweak it. when the
query is run, it asks for the suburb, and then the size, but my problem is
this, the "size" that the user enters needs to be broadened. For example,
let's say the suburb is manhatten, and the size is 100, it must give me all
the records with a size between 50 and 150. (the leeway should be between 50
more and 50 less), so if a size input by the user = 250, then i want all the
records between 200 and 300. is there a way to do this besides using the
"between" operator? please advise.

 

[Allen Browne]

Change the Criteria to:

Between [Enter size] - 50 And [Enter size] + 50

 

[Guest]

Thank you so much Allen, it works perfectly now, preciate it.
--

Change the Criteria to:

Between [Enter size] - 50 And [Enter size] + 50

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi, my problem is this, i have a table with various fields, but for this
question it only uses 2 fields as criteria for it's search. the fields
used
are suburb and size. i am using user input, so in my "criteria" box of the
query (in design view), it reads under suburb: ["Enter suburb"] and under
size ["Enter size"]. this works perfectly, but i need to tweak it. when
the
query is run, it asks for the suburb, and then the size, but my problem is
this, the "size" that the user enters needs to be broadened. For example,
let's say the suburb is manhatten, and the size is 100, it must give me
all
the records with a size between 50 and 150. (the leeway should be between
50
more and 50 less), so if a size input by the user = 250, then i want all
the
records between 200 and 300. is there a way to do this besides using the
"between" operator? please advise.