If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
huge report
I have a database of 12 tables and I would like to get a report from all the
information on the 12 tables is this feasible and how can I do it. I otherwords I want all the information on the database for a certain period |
#2
|
|||
|
|||
huge report
ChenayiChiguvare,
Can you use subreports? Or maybe you'll need a Union query. You can use... Between [Enter Start Date] and [Enter End Date] but without a wee bit more information it's hard to say. Like what is your table structure? How are they related to each other? -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "ChenayiChiguvare" u57316@uwe wrote in message news:a1b70e78bfd66@uwe... I have a database of 12 tables and I would like to get a report from all the information on the 12 tables is this feasible and how can I do it. I otherwords I want all the information on the database for a certain period |
#3
|
|||
|
|||
huge report
Are the tables all similar but have data for different periods? If so you
need to create a Union All query to join all 12 tables. Then use this query as the record source for another query or the report. Also if you do have a dozen tables with the same data, but from different periods, you database is set up incorrectly. All the similar data should be in the same table with something like a date field showing the period for each record. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "ChenayiChiguvare" wrote: I have a database of 12 tables and I would like to get a report from all the information on the 12 tables is this feasible and how can I do it. I otherwords I want all the information on the database for a certain period |
Thread Tools | |
Display Modes | |
|
|