Same field in Reports from different tables.

[G deady via AccessMonster.com]

I have a db for a Personal Injury Law Firm. I have a seperate table for
each type of case-Auto Accident, Medical Malpractice, Slip & Fall Etc.
Each table has a calculated field to record the Statute of Limitations for
that case-(Date of accident plus the statutary time period to file suit).
I want to generate one report tracking the Statutes of Limitations on all
Cases. I am stuck. How do I write a query to return data from 7 or 8
different reports. The report has 4 fields: ClientName, CaseType, Dateof
accident, and Statute of Limitations.The last 3 fields are actually 7 each-
ie 7 Casertype fields from different tables, 7 Accident Sate fields and 7
Statute of Limitation fiends. Can this be done?

 

[Rick B]

You can pull more than one table into a query and then a report.

Personally, I would create one table for all this data and then I would add
a CaseType field. I would not create a separate table for each type of case
unless the structures of the tables are very different. In other words, if
you track different information for each type of case, then your structure
might be okay. Even in that case, I'd probably still have one big table for
the case number and type (and any other common data), and then separate
tables related to that main table for the unique fields.