combining the answers to queries

  • Thread starter Thread starter ProfWdesk1
  • Start date Start date
P

ProfWdesk1

I review a very detailed database every month that comes in from different
sources. I have lots of cross checks of the data. I looks for nulls in fields
that need data and many other issues. I have about 100 queries that each check
about 10 points. I have taken steps to improve the data before it comes in but
I want to continue my error checking. Is there a way to get the results of
about 100 queries or even 20 queries quickly? Roy, (e-mail address removed)
 
All you have to do is create a VBA module that runs each query in turn and
captures the results. Basically, you create a recordset based on the query
and then you can read the recordset in and do whatever you want. You could
create a generic error table with maybe the query name, error code and record
key. Write a record every time a query returns an error. Then you can display
all the errors on a form. A lot depends on what you do with the errors when
you have identified them.
- David
 
Back
Top