RobNauticus
MIS
Hello all,
I would love some guidance on how to structure my reports within my new "normalized" Access DB. Most of my reporting will be based from a single table "DateLog". This table contains the following fields:
PK: JobID, LotID, TaskID, TripID
Other: TaskDate, ForemanID, TaskQty
Each record represents a particular trip to perform a particular task at a homesite.
The current part of the report I am working on requires me to take a record with a TaskID = 21 and subtract the TaskDate from the current date. This is where it gets more complicated...I only want it to show up if there isn't a record for TaskID = 9 and all of the other key fields match. (in other words only show the record if a previous task has been completed at that homesite.
Please let me know if I need to be more clear on any point.
Any guidance would be VERY appreciated!!!
Thanks,
Rob
I would love some guidance on how to structure my reports within my new "normalized" Access DB. Most of my reporting will be based from a single table "DateLog". This table contains the following fields:
PK: JobID, LotID, TaskID, TripID
Other: TaskDate, ForemanID, TaskQty
Each record represents a particular trip to perform a particular task at a homesite.
The current part of the report I am working on requires me to take a record with a TaskID = 21 and subtract the TaskDate from the current date. This is where it gets more complicated...I only want it to show up if there isn't a record for TaskID = 9 and all of the other key fields match. (in other words only show the record if a previous task has been completed at that homesite.
Please let me know if I need to be more clear on any point.
Any guidance would be VERY appreciated!!!
Thanks,
Rob