[AccessD] deduping qry results

William Hindman wdhindman at dejpolsystems.com
Fri Mar 28 11:06:38 CDT 2008


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






More information about the AccessD mailing list