[AccessD] deduping qry results

...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
>