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/
