Results 1 to 3 of 3
  1. #1
    SunTop is offline Advanced Beginner
    Windows 8 Access 2016
    Join Date
    Aug 2016
    Posts
    93

    Database for track roads maintenance company

    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

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you will have the tRoadName table to hold the roads...
    Road A
    Road B

    the tMaint table to show when maint was performed
    Road (from table above)
    MaintStartDate
    MaintCompleteDate
    etc...


    I have a form, on it are 2 text boxes for dates.
    txtStart
    txtEnd


    These will hold the start and end date of the month.
    Code in the form will calculate these dates based on what the user clicks...
    user clicks FEB 2018 , then txtStart = 2/1/2018 and txtEnd = 2/28/2018
    (this could also be done manually)


    the query then uses this to pull data
    select * from tMain where MaintStartDate between forms!myForm!txtStart and forms!myForm!txtEnd


    elapsed time is (in days):
    DateDiff("d",[MaintStartDate],[MaintCompleteDate])
    Attached Thumbnails Attached Thumbnails rpts ytd.jpg  

  3. #3
    SunTop is offline Advanced Beginner
    Windows 8 Access 2016
    Join Date
    Aug 2016
    Posts
    93
    thanks ranman256 for your help

    this is what I was looking for

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Database Relationship for Equipment Maintenance
    By carahorse in forum Database Design
    Replies: 4
    Last Post: 04-25-2017, 10:14 AM
  2. Replies: 4
    Last Post: 08-08-2016, 12:28 PM
  3. Need design help on maintenance database
    By creyc in forum Database Design
    Replies: 7
    Last Post: 03-29-2013, 03:51 PM
  4. Maintenance Database
    By shariq1989 in forum Database Design
    Replies: 1
    Last Post: 06-28-2012, 04:55 PM
  5. Database for Company's Output
    By cg98721 in forum Database Design
    Replies: 1
    Last Post: 06-15-2011, 07:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums