[AccessD] deduping qry results

Gustav Brock Gustav at cactus.dk
Fri Mar 28 12:23:04 CDT 2008


Hi William

Oh, missed that.

Then how about:

  SELECT DISTINCT
    tblExhibitorProducts.EPCID, 
    qryApr08Grid.CompanyID,
    qryApr08Grid.CompanyName, 
    qryApr08Grid.AdClass, 
    qryApr08Grid.SGOn
  FROM 
    tblExhibitorProducts,
    qryApr08Grid
  WHERE
    (tblExhibitorProducts.CompanyID = qryApr08Grid.CompanyID)
    AND
    (tblExhibitorProducts.EPCID=11 
      OR 
    qryApr08Grid.AdClass="A");

or:

  SELECT 
    tblExhibitorProducts.EPCID, 
    qryApr08Grid.*
  FROM 
    tblExhibitorProducts,
    qryApr08Grid
  WHERE
    tblExhibitorProducts.CompanyID = qryApr08Grid.CompanyID;

Feed this to:

  SELECT DISTINCT
    EPCID, 
    CompanyID,
    CompanyName, 
    AdClass, 
    SGOn
  FROM 
    qryTemp
  WHERE
    EPCID=11 
      OR 
    AdClass="A";

/gustav


>>> wdhindman at dejpolsystems.com 28-03-2008 18:01:53 >>>
...but the OR'd records have different EPCIDs and would thus be eliminated.

William

----- Original Message ----- 
From: "Gustav Brock" <Gustav at cactus.dk>
To: <accessd at databaseadvisors.com>
Sent: Friday, March 28, 2008 12:52 PM
Subject: Re: [AccessD] deduping qry results


> Hi William
>
> And so?
> Just specify the parameter in the top query as well.
>
> /gustav
>
>>>> wdhindman at dejpolsystems.com 28-03-2008 17:06:38 >>>
> ...love to but EPCID is a parameter supplied by the user.
>
> William
>
> ----- Original Message ----- 
> From: "Gustav Brock" <Gustav at cactus.dk>
> To: <accessd at databaseadvisors.com>
> Sent: Friday, March 28, 2008 11:57 AM
> Subject: Re: [AccessD] deduping qry results
>
>
>> Hi William
>>
>> Couldn't you just remove DISTINCTROW and then use this query as source in
>> another query where you use DISTINCT?
>>
>> /gustav
>>
>>>>> wdhindman at dejpolsystems.com 28-03-2008 16:43:06 >>>
>> ...senior moment ...posted on another thread by mistake :(
>>
>> ...given the following query:
>>
>> SELECT DISTINCTROW tblExhibitorProducts.EPCID, qryApr08Grid.CompanyID,
>> qryApr08Grid.CompanyName, qryApr08Grid.AdClass, qryApr08Grid.SGOn
>> FROM tblExhibitorProducts INNER JOIN qryApr08Grid ON
>> tblExhibitorProducts.CompanyID = qryApr08Grid.CompanyID WHERE
>> (((tblExhibitorProducts.EPCID)=11)) OR (((qryApr08Grid.AdClass)="A"));
>>
>> ...how can I avoid duplicates in the OR results?
>> ...I've tried totals and uniuqe values/records but nothing produces
>> consistent results ...help!
>>
>> William
>
>
>
> -- 
> 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





More information about the AccessD mailing list