Hello everyone
I am trying to design a database for a track roads maintenance company. The company will be provided with a list of roads from the client, each road takes a predetermined time to maintain it, some roads will take a day others maybe a day and half or maybe only half or third of a day. The company must maintain all the roads monthly. The company uses an excel sheet now which it repairs manually each moth as follows
Road Name Maintenance completion date Road A Jan / 5 / 2018 Road B Jan / 7 / 2018 Road C Jan / 11 / 2018
etc …
I would like to design a database that will generate this report automatically. I would like to create a table in the database that contains the road names and how long it will take to maintain them and the database will generate a report (via a query or vba) and I would like the report to skip Sundays because the company does not work on Sundays and I would like the report to adapt itself for the varying length of months (30 or 31 or 28 or 29 days in month)
Thanks in advance