append mult. tables into one

[Theresa]

I'm using an Access 2000 database with at least a dozen error tables my
boss created. They all start with Tutume_err_ They all have three fields in
common: patient number, facility and log book number. I'm trying to create
one list of the records that I need to verify against the logbook. We need
to make sure it was the person that wrote in the logbook that made the error
and not our data entry clerk. I'm going to have to do the same thing for 25
other districts. Is there any way to automate this in VB6? Or do you have a
better suggestion of how to accomplish this?

TIA,
Theresa

 

[Theresa]

Update:
I created a union query with two of the tables and it worked. I then
created an insert query using the union query in the FROM clause. That also
worked.
Does anyone know how many unions I can string together in Access 2000?

Theresa

 

[Van T. Dinh]

There is a limit of 32 Tables max in a Query so I guess the max number of
unions is 31.

Also, the SQL String is limited to 64K characters (I guess I would get very
confused long before I get to this limit).