[AccessD] Automating Acrobat

Two queries - one to set up the records with dups and a second one using the
first one but properties Unique Values - Yes? 

Rocky



 	
	

-----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:40 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Automating Acrobat

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

No virus found in this incoming message.
Checked by AVG. 
Version: 7.5.519 / Virus Database: 269.22.1/1347 - Release Date: 3/27/2008
7:15 PM