Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    South Carolina, USA
    Thanked 0 Times in 0 Posts

    Scheduleing database (97)

    I have created a very small scheduling system and now the boss wants to make some changes. Currently, if you need to schedule a class for 3 days, you have to enter each day separately. I need some assistance on how to schedule 3 days ( or more) at one time. She does not like doing each day individually. I would like to put a start date and ending date and then let the database populate all the other fields. I also need for it to jump over the weekends. We do not work on the weekends. I may have a class on Tues, Thur and the following Tues.

    Any ideas! You guys are always so helpful.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Scheduleing database (97)

    If you have a class on Tuesday, Thursday and the following Tuesday, I don't see how the dates could be generated automatically from a specified start date and ending date.

    The attached database shpws how to create a series of contiguous dates (excluding weekend days, not taking holidays into account). It's just meant as a demo, not as a finished application.

Posting Permissions

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