Query a field with data 1-20 eg.?

W

Wayne

I need to query the field with data like 610-620,650-699 and ask it to return
any record that falls either = to or in between. Is it possible, or do I
need to make low and high field and enter data records in this case two
records?
low high
610 620
650 699

Ask for 655
 
J

Jeff Boyce

Wayne

I suspect you'll find it easier to use the "low & high" approach than to
allow a range, then have to work out how to "parse" that range to discover
the low and high values.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query to find a range of data 8
Creating a Chart on form from selected data in query. 0
Copy previous record into form field 0
Getting the first data point from a list of data 3
Page numbering with Merged Document and IF statements 1
Multiple "BETWEEN...AND" statements 2
Select data and sum by weeks in a month 3
Using Multiple Parameters in a Query 2

Top