Hello everyone,
I was wondering if you be able to tell me if it is possible to create what I'm hoping to do in access.
In my situation i have tasks that need to be completed on a weekly and a monthly schedule and then the following week or month I have to complete those same tasks all over again. Is it possible to have access reset my tasks at the beginning of each week and month respectively but before doing so print out and save a report for that week or month the tasks that did and did not get complete?
The less hands on of changing each completed task back to incomplete at the end of the week would be great as i have a lot of tasks that are both weekly and monthly. I would like a printed report for record keeping along with a saved document of the report to hopefully use in showing over time (quarterly and yearly) what tasks get completed more often then other tasks so i will be able to make a better and more informed decision on how to tackle the problem of tasks not getting completed on time.
As i am still getting used to creating and designing within Access the forms, queries, etc.. I have figured this is going to be my biggest hurdle and the "make it or break it" problem i will face. Any information on how this could be accomplished would be greatly appreciated. If you need more information please let me know as i know this is a very broad example of what i need to accomplish.
Cheers,
Moltin