William Hindman
wdhindman at dejpolsystems.com
Fri Mar 28 10:43:06 CDT 2008
...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