Access dates help please!

[gjoneshtfc]

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

 

[Joseph Meehan]

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