Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2004
    Posts
    3

    Unanswered: How to plan ahead?

    Hi.

    I am developing a db that will administrate working hours for shift workers. Now, as a shift worker you know how your hours are put out at least a year ahead.

    I want to be able to, in a form or some other solution, be able to make the entries for a person in a similar way you can pre-schedule a meeting in Oulook. In Outlook you are able to schedule "meeting every monday between 13.00 and 15.00 every seventh week, ending at 2005-01-01". Thus you can be able to pre-schedule the hours for every person.

    I hope you know what I mean.

    Is it possible to solve in an easy manner?

    /Rapid

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You're basically going to have to re-invent outlook, butyes, this can be done.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Oct 2004
    Posts
    3
    Thank´s for the answer.

    I don´t need Outlook to do the job, just get the "algoritm" type in access.

    Am I on the right track if I create a tbl wich contains columns for date, starttime, endtime and make a script which task is to:

    Put valueSTARTTIME in rowSTARTTIME and valueENDTIME in rowENDTIME at valueDATE+3*7

    The dates are preentered for say 10 years.

    Is it possible to use the Date function in anyway?

    Does anyone know of some good litterature dealing with dates, hours and so on?

  4. #4
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Access online help has good examples on using the DateAdd function as well as Date Formatting which might be very helpful to you.

    Bud

  5. #5
    Join Date
    Oct 2004
    Posts
    3
    Thanks.

    I´ll look it up.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •