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

[Guest]

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?

 

[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.

 

[Joseph Meehan]

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?

It's hard to tell from here, but it would appear the first step is to
re-organize your data. Generally you would have only one table for all
contacts. Multiple addresses etc are handled by related tables, not by
having various unrelated tables of groups of contacts.

 

[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?

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]

 

[Guest]

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.

 

[Guest]

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.)

 

[Joseph Meehan]

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.

Frankly I believe that you will save time and create a much better
product is you start with the basic design rather than trying to pug the
holes in a bad table design. Spend the time you are not wasting by fixing a
broken design by working on a proper design. It's time to bite the bullet.