Kaup, Chester
Chester_Kaup at kindermorgan.com
Thu Jun 3 07:21:33 CDT 2010
4 records is the correct answer. 4 records return a value of -1 and 96 return a value of 0. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Fred Hooper Sent: Wednesday, June 02, 2010 4:53 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Query question Agreed, weird. I guess it comes down to what's right: 100 or 4 records? On 6/2/2010 5:07 PM, David McAfee wrote: > That's so weird. It's basically saying WHERE True = -1 or WHERE False =-1 > > On Wed, Jun 2, 2010 at 1:55 PM, Kaup, Chester > <Chester_Kaup at kindermorgan.com> wrote: > >> Apparently something else is going on because without the -1 I get 100 records and with it 4 records. If I look at the results each record returns a 0 or 1. >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Fred Hooper >> Sent: Wednesday, June 02, 2010 3:19 PM >> To: Access Developers discussion and problem solving >> Subject: Re: [AccessD] Query question >> >> Hi Chester, >> >> It looks like "-1" is a synonym for True, and therefore redundant in a Where clause as nothing would be returned unless the Where clause were True >> WHERE ( >> (([Status]='WAGC' And [Design_Fluid_Status_Id]='WI') >> Or ([Status]='WAGW' And [Design_Fluid_Status_Id]='CI') >> Or ([Status]='CI' And [Design_Fluid_Status_Id]='WI') >> Or ([Status]='WI' And [Design_Fluid_Status_Id]='CI')) >> =-1) >> >> This would do the same thing: >> WHERE >> (([Status]='WAGC' And [Design_Fluid_Status_Id]='WI') >> Or ([Status]='WAGW' And [Design_Fluid_Status_Id]='CI') >> Or ([Status]='CI' And [Design_Fluid_Status_Id]='WI') >> Or ([Status]='WI' And [Design_Fluid_Status_Id]='CI')) >> >> Fred Hooper >> >> On 6/2/2010 3:13 PM, Kaup, Chester wrote: >> >> >>> This is part of a query that someone gave me. I am not sure what it is really doing. I am thinking it returns a value of -1 if any of the conditions are true. Is that correct? I have not in my limited experience see anything like this before. Is this the best way to do this? Thanks >>> >>> WHERE ((([Status]='WAGC' And [Design_Fluid_Status_Id]='WI') >>> Or ([Status]='WAGW' And [Design_Fluid_Status_Id]='CI') >>> Or ([Status]='CI' And [Design_Fluid_Status_Id]='WI') >>> Or ([Status]='WI' And [Design_Fluid_Status_Id]='CI'))=-1) >>> >>> >>> Chester Kaup >>> Engineering Technician >>> Kinder Morgan CO2 Company, LLP >>> Office (432) 688-3797 >>> FAX (432) 688-3799 >>> >>> >>> No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. >>> >>> >>> >>> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> >> > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com