Access 2003 Union Query - thread181-914570

[Anushkas]

Hi there,

Can one of you experts pls help me. I have 4 Access 2003 databases used by 4 different area offices. They are identical databases except that each area office has to be kept separate for confidentiality reasons.

The databases have several tables but one main TABLE named PAT is the one that contains Client records.

for ex:
area office Ottawa has 200 records in PAT Table
area office Toronto has 400 records in PAT table
area office Ottawa has 200 records in PAT table
area office calgary has 100 records in PAT table

Each of these tables have a Masterno as the key but linking them will not do anything as each of them have an identified set. No common links. But all fields from the tables have same name etc.. except the db has different name.

All Along at the end of every mth i have merged them manually to get a Regional table called PAT and do the stats. I am planning on moving the db to a more secure SQL platform but prior that I want to make sure i can access the data.

The help i am looking for is that I want to do away with the manual appends i have to do every mth.

Is there a simple way of seeing all 900 records using a union query and use that query to do my monthly stats?

If it is possible how shd i do this. I am lost here. Any help or pointers to help is appreciated.

Thanks a lot

Usha

 

[MakeItSo]

Please don't make two threads to the same issue.
See my reply in the other one.
;-)

Cheers,
miS

[navy]"We had to turn off that service to comply with the CDA Bill."[/navy]
- The Bastard Operator From Hell