Bill, Try OR instead of AND. Eric
-----Original Message----- From: Bill Haskett [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2008 11:19 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Friday query logic Jeff: I could only get a single criteria to work... list APOPEN WHEN ANY ACCTS UNLIKE "52..." INVDATE COMMENT ACCTS AMTS APOPEN.... INV-DATE DESCRIPTION........................ ACCT. ACCT/AMTS.... 58*6-4 06-01-08 LOAN #123456, 06/2008 2910 1,025.50 2365 61.08 2980 273.70 ...or... list APOPEN WHEN ANY ACCTS UNLIKE "29..." INVDATE COMMENT ACCTS AMTS APOPEN.... INV-DATE DESCRIPTION........................ ACCT. ACCT/AMTS.... 58*6-4 06-01-08 LOAN #123456, 06/2008 5230 246.04 2365 61.08 5230 50.00 ...but adding both criteria together with an AND/OR failed... list APOPEN WHEN ANY ACCTS UNLIKE "52..." AND WHEN ANY ACCTS UNLIKE "29..." INVDATE COMMENT ACCTS AMTS APOPEN.... INV-DATE DESCRIPTION........................ ACCT. ACCT/AMTS.... 58*6-4 06-01-08 LOAN #123456, 06/2008 5230 246.04 2910 1,025.50 2365 61.08 2980 273.70 5230 50.00 ...using WITH instead of WHEN had no effect... list APOPEN WITH ANY ACCTS UNLIKE "52..." AND WITH ANY ACCTS UNLIKE "29..." INVDATE COMMENT ACCTS AMTS APOPEN.... INV-DATE DESCRIPTION........................ ACCT. ACCT/AMTS.... 58*6-4 06-01-08 LOAN #123456, 06/2008 5230 246.04 2910 1,025.50 2365 61.08 2980 273.70 5230 50.00 This is on UD v7.1.9 (Windows 2K3). Did I miss something? Bill >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of Jeffrey Butera >Sent: Monday, June 23, 2008 10:20 AM >To: u2-users@listserver.u2ug.org >Subject: Re: [U2] Friday query logic > ><quote who='Eric Armstrong' date='Monday 23 June 2008'> >> Jeff, >> In Universe there is a (apparently undocumented) keyword ANY which can be used, i.e. >> >> SELECT FILE WITH ANY FIELD UNLIKE SF... OR WITH ANY FIELD UNLIKE SH... >> >> which may be just what you want. > >Eric: > >You get the prize - I'm on Unidata but ANY works the same and it's exactly >what I want. On your next hot day I owe you a cool beverage of your >choice... > > >-- >Jeff Butera, Ph.D. >Administrative Systems >Hampshire College >[EMAIL PROTECTED] >413-559-5556 ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/