I need some input on if what I'm thinking will work. I currently track data via excel and would like to move to access.
How can track a single record for activity being done on multiple dates?
Here is what I mean for said record:
"crew1 work the yard on 12/8/22, crew 1 finished the yard on 12/9/22, but for the same record crew 2 washed the house on 12/7/22". Also how can I account for how much of said yard or house was completed per day?
At the moment I track everything via excel and I have 1 month per tab and I built the days like a calendar where I manually enter the data, but I have to go back searching through months versus having a nice database I can use in a more robust way. there is more data I track but I'm trying to understand how to address the multi-date or multi-crew for one record issue.
Also any ideas on how to build a calendar that is viewable with the different jobs per day?
I can provide more detail if needed.
Any help is greatly appreciated!
Thanks