Create a report from multiple tables/merge data in multipletables?

K

Kylie

We have several mailing lists set up in simple databases. Is there any way
to create a report of all mailing lists from the several databases?
 
D

Douglas J. Steele

Why not put them all in the same database?

Failing that, you can link one database to another, so that you can query
all of the tables from a single database.
 
J

John Vinson

We have several mailing lists set up in simple databases. Is there any way
to create a report of all mailing lists from the several databases?
Click to expand...

Are these several Access .mdb file DATABASES? or are there several
TABLES within one database?

A UNION query (see the online help for UNION) is probably what you'll
need, but if there are tables in different databases you'll also need
to use File... Get External Data... Link to link to them, or use the
IN operator (again see the online help) to specify the remote database
name.


John W. Vinson[MVP]
 
K

Kylie

At this stage, each of our tables contain a variety of data (there are some
common fields) and we need to keep our databases seperate because of the
sources of information. It definately would make life easier if they were
all in one though I agree! Hopefully this will be a possibility in the near
future.
 
K

Kylie

Hi John

Thanks for your help. Yes, a union query was the answer pretty much.
Although I did still have some trouble when one of the tables didn't include
a field that I needed data from in the other tables, and ended up having to
delete that table from my query unfortunately. Do you know if there is a way
around this? (My Access knowledge is very basic - I'm pretty much teach
myself and have never worked with multiple tables before.)
 
Top