Report help

M

Maggie

I have like 20 tables(each table is a member number) that have all
the same titles but different data. Is there any way to do a report
with different member numbers? or do I have to do a huge table?
 
A

Amy Blankenship

Maggie said:
I have like 20 tables(each table is a member number) that have all
the same titles but different data. Is there any way to do a report
with different member numbers? or do I have to do a huge table?
Click to expand...

It should all be in one table.
 
M

Maggie

It should all be in one table.
Click to expand...

okay I will put it in one table but for one set of data there are a
few titles that are different. Do I put that in one huge table?
 
J

John W. Vinson

I have like 20 tables(each table is a member number) that have all
the same titles but different data. Is there any way to do a report
with different member numbers? or do I have to do a huge table?
Click to expand...

Do you have, on average, over 1,000,000 records in each of these tables? If so
I'll accept your "huge" description (and suggest you move the data to
SQL/Server). If you're talking about tens of thousands of records or fewer in
total, you're in fact using very modest sized tables.

In any case, huge or not, one table is very clearly better than twenty
identically structured tables. I don't know what you mean by "different
titles" - could you explain?

That said... you can use a UNION query to string these separate tables
together into one recordset for a report. See the online help for UNION. (You
may want to use an Append query based on this UNION query to populate your
properly-normalized "huge" table in any case).

John W. Vinson [MVP]
 
Top