[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