Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Fri Mar 28 18:27:53 CDT 2008
You know, this is the point at which I usually turn to code - a couple of DAO recordsets, a few loops and walla - you've got the data you need in a temp table in less time than it takes to figure out how to make queries jump through that hoop. 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 12:22 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Automating Acrobat ...the EPCID is used to call other actions specific to it ...but I'll take a look at trying that if Patricia's code doesn't work first. 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 2:50 PM Subject: Re: [AccessD] Automating Acrobat > 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 > > > -- > 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