Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Access dates help please!

Discussion in 'Information Technology' started by gjoneshtfc@volcanomail.com, Nov 3, 2005.

Tags:
  1. gjoneshtfc@volcanomail.com

    gjoneshtfc@volcanomail.com
    Expand Collapse
    Guest

    Hello

    I am trying to set up a database that will be used for booking computer
    courses. I have a table with all the courses in and the course length
    (each course runs for a different number of weeks).

    What i would like to have is a form where i select the course the
    student wants, and the week they want to start. I then want a list
    creating with the sessions available for the course. Sounds a simple
    idea but i have no idea of how to do it! With the courses running for
    different weeks the list will have to be created after checking every
    session for the number of weeks the course runs and then only returns
    sessions that can fit the course in every week.

    We will get to that bit later though... at this moment i am wanting to
    know the easiest way to create a "week commencing" table. The only way
    i know is to type every monday date into a table. Not something i want
    to do as this database will be used for years!

    Can anyone suggest a quick way of generating this table please?!

    Thanks for your help,
    Kind regards, Gareth Jones
     
  2. Loading...


  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    gjoneshtfc@volcanomail.com wrote:
    > Hello
    >
    > I am trying to set up a database that will be used for booking
    > computer courses. I have a table with all the courses in and the
    > course length (each course runs for a different number of weeks).
    >
    > What i would like to have is a form where i select the course the
    > student wants, and the week they want to start. I then want a list
    > creating with the sessions available for the course. Sounds a simple
    > idea but i have no idea of how to do it! With the courses running for
    > different weeks the list will have to be created after checking every
    > session for the number of weeks the course runs and then only returns
    > sessions that can fit the course in every week.
    >
    > We will get to that bit later though... at this moment i am wanting to
    > know the easiest way to create a "week commencing" table. The only way
    > i know is to type every monday date into a table. Not something i want
    > to do as this database will be used for years!
    >
    > Can anyone suggest a quick way of generating this table please?!
    >
    > Thanks for your help,
    > Kind regards, Gareth Jones


    Hint: Using the format "dddd" will return the day of the week eg.
    Monday

    --
    Joseph Meehan

    Dia duit
     

Share This Page