[AccessD] deduping qry results

gustav

...no ...both gave the same results I've been getting :(

William

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


> 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
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>