[AccessD] Automating Acrobat

William Hindman wdhindman at dejpolsystems.com
Fri Mar 28 10:39:56 CDT 2008


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






More information about the AccessD mailing list