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, but i am responsible to do this, can you do it for me please ?
- in excel the dates are in 2012, i need to reach my today date to see what tasks need maintenance today but in access
i am new to access i do not know how to work in access, can you help me and do it for me pleaseI 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
