G
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?
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?