Forum Discussion
mok1995
Jun 30, 2021Copper Contributor
date increasing
Hello all I have an excel sheet containing information for many machines that needs maintenance, each machine has a starting date of maintenance and the maintenance will be done repetitively in a sp...
George_Hepworth
Jun 30, 2021Silver Contributor
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.
mok1995
Jun 30, 2021Copper Contributor
i am new to access, but i am responsible to do this, can you do it for me please ?