Forum Discussion
date increasing
In addition to the basic functionality needed, it is interesting to look at the names of the columns in your worksheet and speculate why they are what they are. It looks to me, as a matter of fact, this is probably an exported query from another database. Tables in that source database are probably:
Sections
Machines
Parts
Tasks
And maybe one other for People Needed, wherever that comes from.
If that's case, I'd strongly recommend bypassing this intermediate Excel step and go directly to that source database to run your queries to get due dates for maintenance.
i am new to access i do not know how to work in access, can you help me and do it for me please
I am retired and I no longer take on client work.
It sounds like this is one of those situations where you have to make some investment, either in the form of effort to learn how to use tool, or in the form of paid consultation to do it for you.
You have data from 2012, correct? That's nine years old. What's been happening in that time? How has this been done? Who did it before? Do you know where the data actually came from? How would you expect to advance the dates? Are all of those machines still in operation after nine years? No new machines? No obsolete machines? At a minimum I'm going to guess this would be a 30 - 50 hour project, if it is done properly. That's much more than is possible in a forum like this unless you are able to do the bulk of the work yourself.
- thank you so much, it is a project for university, but i am new user in access
really thank you dear- "...it is a project for university...."
Do you mean that it is a part of a class you are taking at your university? Or that you are taking on the project while working for the university?
If it is the former, then the best option would be to ask the teacher of that class for assistance.
If it is the latter, then the best option is to discuss this with the person who hired you and clarify your ability to perform the work.
