How to find a number between ranges

[reidi_lexi]

How will I do it on code when I need to find a number between ranges. Example, i have a range start and range end fields. record number one start is 1 and end is 5, next record starts with 6 and ends with 10 and so on. Once I have searched the number 3, it will return the first record.

Help anyone?

 

[boblarson]

What do you intend to use this for? The reason I ask is it will have a bearing on how we go about this. So, are you trying to find the record in a form? Are you wanting a report to display it based on the number entered? Are you wanting a query to view or export the data? What exactly?

 

[reidi_lexi]

I actually have list of coupons that were entered based on the first and last numbers of the coupon series. Upon retrieval, not all coupons within that series will return. What I would want to do is, I have a search box in a form that when I entered the returned coupon number, it will return the first and last numbers of the coupon so that I will know which series it came from…

 

[John Big Booty]

If all you want to do is determine the first and last digits of your field you could use the Left() and Right() functions.

 

[Brianwarnock]

Where [returned_number] Between [Start_number] and [End_number]

Brian

 

[reidi_lexi]

Thanks for all of your reply. I did it already and it is similar with what Brianwarnock suggested...