No replies to this topic

[BlueWednesday]

Ive got to create a booking system on access for a village hall and I have two questions.
There are two types of bookings, Occasional and Regular.
Each of these has its own table with the fields:

Date
Day
Time

I need to link the date and day together so access automatically calculates the day by inputing the date. Thats the easy problem!

The second problem is for regular bookings it may be:

Playgroup - Every monday and wednesday morning

I have no idea how i can input this into fields so it calculates that every date(mondays and wednesdays) throughout the year is taken.

Many thanks