User to enter parameters between two numbers NOT dates

[Gee]

I have an Access db where one of the fields is "Population".
I need the user to enter a start number and end number, so they can get, say the models with a "Population" between 10 and 1000.
I see answers all over, but they either refer to start and end dates, or the numbers are in the code, not in an input box.
Thank you for your help.

[ketbdnetbp]

Gee -

One easy way would be to...

Create a query that includes the "Population" field. In design view, add:

>=[Start Number?] And <=[End Number?]

to the criteria row of the Population column. Then open the query and you will be prompted for a Start Number and then an End Number, fill in both and the query should return records that are between those parameters.

All the best,

Jim

[Gee]

I thought that would work also, but it only gave me data under the 2nd input, the first input it ignores.
Any other suggestions?
thanks!

[Gee]

I just realized...I imagine it makes a difference if it's "varchar" rather than "numeric"?
HAH!

[Gee]

OK, I just went through the process of changing it to numeric and it still doesn't work...no data is returned.
Help?

[Gee]

I did a bit more tweeking and it worked!

Thank you so much for your help.

>=[Start Number?] And <=[End Number?]

[ketbdnetbp]

Gee -

Glad you got it working. Please mark thread as Solved.

Happy to help,

Jim

[Gee]

I cant' see where to mark as solved.

[ketbdnetbp]

Gee -

In the green bar just below thread title, select Thread Tools, then Mark as Solved.

All the best,

Jim