Hi all
I'm new to this forum and MS Access as well!
I've only started learning this past week.
What I'm trying to do is create a database for a paper task that my team does at work.
They have a paper checklist of various tasks that need to be done each date to stay on top of BAU tasks.
Each day has different tasks although some are common.
They pass it on to each other to tick it off and see what tasks have been done already and what needs doing so they're not missed off.
I'm trying to think at the moment how to design it, in terms of how do I structure this with tables, queries etc but I'm coming up short and going around in circles..
Essentially I'd like to transfer the paper copy they have that they tick off as completed and put down their initials and the time it has taken them to complete the task.
I also would like to be able to export that as a report later but I think I'll need to overcome the first hurdle of actually designing it.
So far I have only managed to create a continuous form with a drop-down list of task categories, initials, time taken for other tasks.
This is for other ad-hoc tasks and that works ok so far but I don't know to transition to the day specific checklist..
I'm not looking for anything fancy or glamorous, just to transition seamlessly their paper process to a database where I can also get quickly MI with who spent what time and on what task and on which days etc.
Any assistance would be greatly appreciated!!
Many thanks