I have attached a local table copy, but the real thing is 2700 records and 31 days each month on SharePoint. Currently a supervisor logs in and updates the column that I open up in the Default SharePoint view every evening for that following day. I then have several other reports and queries, each needing to be edited every single day for the day we are on...
IE; today is the 10th, but tomorrow the column I need to look at is going to be the 11th.
I want to start over, and create something similar with the same data available, but where I do nothave to change every query/report to run it. If I want to take the day off, Ihave to prep a new DB for someone the next day so they can print reports forthe boss. If I want to take 5 days off, I have to create 5 DBs.
This was originally a temporary solution and now it lookspermanent so I really need to make this more novice friendly, not that I am anexpert, but I couldn’t ask any random person to manage this for a week or more.
Thoughts?