 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / June 2007Report help
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? >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? It should all be in one table. On Jun 29, 1:30 pm, "Amy Blankenship" <Amy_nos...@magnoliamultimedia.com> wrote: > >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? > > It should all be in one table. 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? >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? 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] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.