huge report

[ChenayiChiguvare]

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

 

[Gina Whipp]

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

 

[Jerry Whittle]

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.