How about: select myfile with every qty ge "1000" and le "2000"
works for me on UV 10.1.4. Note that in D3, I think your original query would work as you had hoped. /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 On Dec 19, 2007 7:37 AM, Russ Watson <[EMAIL PROTECTED]> wrote: > I want to select records to report if *one* of the multivalues falls > within a range. > > For example: select with qty >= 1000 and =< 2000 > > If I use the example I get records where none of the values satisfies > the range condition. > > @ID qty > --- --- > 1129 2,500.0 > 2,500.0 > 300.0 > > > Russ > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/