Thanks to all who replied. The quandary was how to *select* the appropriate records without having to change the ensuing basic report.
I was hoping for something like BETWEEN. But between does not work on multi-valued fields. By-exp would have required additional programming changes. In the end it was easier to do the quantity check in basic and discard the exceptions. If the phase "with qty >= 1000 and =< 2000" is actually interpreted as "with qty >= 1000 OR =< 2000" when a multi-valued field is evaluated, then I would have expected to get all records - which does not happen. Russ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Wednesday, December 19, 2007 2:01 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] selection of multivalued field based on range Hi Russ, To get a listing of just the data you want you'll probably need to use the BETWEEN key word along with BY.EXP and WHEN Something along the lines of: LIST filename BY.EXP fieldname WHEN fieldname BETWEEN "1000" "2000" I'm not sure of the BETWEEN syntax so you'll need to look that up. But you need to use BETWEEN, as only one WHEN per statement works. hth, Allen E. Elwood www.tortillafc.com Quality Code Since 1978 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Russ Watson Sent: Wednesday, December 19, 2007 07:37 To: u2-users@listserver.u2ug.org Subject: [U2] selection of multivalued field based on range 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/
