Re: run queries by the batch

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

.

Relevant Pages

  • Re: is there a spreadsheet for football dreamteams
    ... This is a newsgroup to help people write queries in the application ... Microsoft Access. ... Rick B ...
    (microsoft.public.access.queries)
  • Re: JRRT again: CS Lewis was: Darwin, Jesus and Moses... and Wilderness
    ... My friends point out that Oxfrod's dark Nationalist Socialist secret was ... >>>books are too big and baggy and could do with editing. ... I just met Rick last year and have been meaning ... >>Over time, my opinions of Asimov has tarnish a bit, but he's OK. ...
    (rec.backcountry)
  • Re: The Condition of the Church in the UK vs USA
    ... The books may be seemly innocent, ... Christian Research Net, and Apprising Minstries. ... I only looked at this one, I'm not a great fan of Rick Warren. ... his books are Biblically lightweight and take the Bible in particular ...
    (uk.religion.christian)
  • Re: Status Field
    ... In a query, you'd create a new column and put something like the following ... Rick B ... your queries, forms, and reports to create the status on the fly. ... I want to create a field in my contracts tracking table to ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Table or Query ?
    ... Rick is correct regarding any significant performance difference, ... I think this setup is more convenient when creating new queries, forms, reports... ... a single record, then get them into the correct format using a query? ... I know the first solution will be more efficient and quicker ...
    (microsoft.public.access.tablesdbdesign)