search price between ranges

[history]

Hi Brothers,

I've a small database containing data about prices of shops, flats and lands
all I need how to get results using price search between a range.
for example :
the client need to search a flat between : 15000 - 20000 $

Thanks for help

 

[John Big Booty]

Check the example here. The working with Numbers section

In short you can use the following in your Criteria row;

Between 15000 And 20000

 

[history]

Thanks for your help

but I want the client search according to his need not according to static prices
for example:
There are flats with price : 15250 $ - 15500 $ - 16750 $ - 18100 $
may be the client need price in range 15000 $ - 16500$
so the results should give 15250 $ - 15500 $ only
It's a way to reduce the search

Thanks a lot

 

[John Big Booty]

You could have two unbound text boxes on your form and use the following criteria;

Between [Forms]![FormName]![TextBox1] And [Forms]![FormName]![TextBox2]

You will of course need some code to valid the values input in those two text boxes prior to running the query.

 

[history]

Thanks Jhon

but regarding the code : How could I do it ????

 

[John Big Booty]

You can put it in the Criteria row of your query design grid below the date field you are querying.

 

[John Big Booty]

Have a look at the attached sample.

Have a look at the two queries that are populating the combo boxes, as well as the one that is providing the results.

 

[history]

Thanks a lot for your extreme help
I think it will work with my database

I'll try and inform you

Thanks again