Re: run queries by the batch
- From: "Tonk" <mtonkovich@xxxxxxx>
- Date: 29 Dec 2006 04:19:06 -0800
Rick - Thanks for the reply. As for the bad data, it comes with the
territory. I'm dealing with nearly 250,000 forms complete by nearly
that many people, some who don't care if I can read the form and others
who just can't read :). Some clean up is a reality. Ultimately, I
will be writing sophisticated queries, but until that time... Which
brings me to a question I plan to post to the group - I've got two
books - Michael Alexander's - Microsoft Access Data Analysis and
Virginia Andersens' MS Access 2002 - The Complete Reference. Both are
good books, espeically Alexander's, but only scratch the surface on
subqueries and the like. Could you recommend a book that covers
queries in great depth?
Thanks Rick and Happy New Year!
Mike
Rick Brandt wrote:
Tonk wrote:
Rick - Thank you. Is that a common practice? I'll experiment with
that. Is that a common practice and if so, under what conditions
would one normally want to use such code?
I don't think it is particularly common to need to run multiple action queries
in sequence, but when that is required then executing them in a VBA procedure as
in my example is the most straightforward way to do it that I can think of.
If you are doing this to clean up bad data then perhaps you should explore why
you are getting bad data in the first place and prevent it at the source.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
.
- References:
- run queries by the batch
- From: Tonk
- Re: run queries by the batch
- From: Rick Brandt
- Re: run queries by the batch
- From: Tonk
- Re: run queries by the batch
- From: Rick Brandt
- run queries by the batch
- Prev by Date: Re: discrepancy between SQL and Design view
- Next by Date: Resources for Writing Advanced Queries
- Previous by thread: Re: run queries by the batch
- Next by thread: sql statement with error #933
- Index(es):
Relevant Pages
|
