Complicated append query

[din2005]

Hi all,

I would like to make append query which adds dates for the next 2 years but also adds slot 1 to 3. But does not include sundays.

basically a query that creates dates monday to saturday and each day has 3 slots.

e.g
DiaryDate Slots
19/02/2007 1
19/02/2007 2
19/02/2007 3

20/02/2007 1
20/02/2007 2
20/02/2007 3

21/02/2007 1
21/02/2007 2
21/02/2007 3

22/02/2007 1
22/02/2007 2
22/02/2007 3


etc

Could anyone give me an example to get me going?

Many thanks

 

[Remou]

I suggest you use a Calendar table that either flags or excludes holidays and weekends in conjunction with a Number table:

[tt]INSERT INTO tblAppendTo ( ApptDate, Slot )
SELECT tblCalendar.Calendar, tblNumbers.Slots
FROM tblCalendar, tblNumbers
WHERE tblNumbers.Slots<=3[/tt]

 

[din2005]

Thanks for replying,

how would i change this so it works with....

tblAppointments

and fields are DiaryDate and Slots

Also i don't want to exclude holidays or weekends now?