[AccessD] Automating Acrobat

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Fri Mar 28 13:50:33 CDT 2008


In the second query can you include all the fields EXCEPT EPCOD and use
unique values?  Do you need the EPCID in whatever is calling that query?

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

...that would be the normal approach but EPCID is a parameter and isn't
known until the user supplies it ...thus I can't dedupe before hand since
the data caught by the OR almost certainly has differing EPCIDs ..I'm
thinking about using a UNION but those always make my head hurt :(

William

----- Original Message -----
From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Friday, March 28, 2008 12:08 PM
Subject: Re: [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
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



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




More information about the AccessD mailing list