The main table for the database I am working on contains the following fields:
ID
Mfr Control Number
Initial or Follow-Up
Follow-up Number
Suspect
Date of Initial Email
Date Received
Date Submitted
Date of Report
Serious
Brief Description
Causality
Notes
With some additional...
I am trying to accomplish something with a query that I thought would be fairly simple and instead seems not to be. Basically we have reports under a specific report number. Each report is required to have follow-up reports (under the same report number) so there is a field to indicate "initial"...
