BETWEEN

D

Dan @BCBS

I'm trying to Open a report based on a range.
The following works for one GROUP:
Left(rstemp!GROUP, 9) = "99999-pbd"

But I need to set it to a range like: BETWEEN "99995-002" and "99995-099"

This does not seem complicated but it's got me stumped.

Thanks
 
C

CyberDwarf

Dan

Given this is a text field, you may get into trouble with the unexpected
sort ordering with the numbers (especially 0)

That said, BETWEEN should work. If not, use >= and <=, but it amounts to the
same thing

HTH

Steve
 
Top