Query a field with data 1-20 eg.?

  • Thread starter Thread starter Wayne
  • Start date Start date
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
 
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
 
Back
Top