BETWEEN

[Guest]

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

 

[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