[AccessD] deduping qry results

Charlotte Foust cfoust at infostatsystems.com
Fri Mar 28 11:53:43 CDT 2008


William, if you're only joining tblExhibitorProducts in order to filter
aryApr08Grid.CompanyID, Why not use an In and a subquery on
tblExhibitorProducts.CompanyID filtered by the EPCID entered instead of
an inner join?

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
Hindman
Sent: Friday, March 28, 2008 8:43 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] deduping qry results

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