Russ, I use this form: >select file by-exp qty >= "1000" and <= "2000" ____________________ Antonio Carlos Departamento TC)cnico Integral Sistemas Telefone 11 3205-6000 - Fax 11 3205-6001 www.integral.com.br ______________________________________________________________ GPG signed/encrypted mail welcome. OpenPGP ID: 0xC1FD2134 Fingerprint: 294C DF90 1648 D58B C279 0C9A 46B9 7DE2 C1FD 2134
Russ Watson 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/