For my coursework I am making a database for a school, and the aim is to create a booking system where teachers can book the ICT room. What I am trying to do is make a system where teachers fill in the booking information in a form, and then they will be able to view the timetable in a report through a query, including all periods that havent been filled. I would prefer if this was how it is done, because my write up states that is how I am doing it.
Unfortunatley this coursework has to be completed by friday, so i would appreciate if someone could help me as soon as possible please.
Im using access 2003. I have hosted the databse for you to look at.
Thnaks for the reply, theres my database and my table structure.
We started it in January, so we've had enough time, and its got to the point where ive done everything but my main feature. I just need to have some way of making the timetable in a report, so the blank periods come up aswell in the report.
... so after 4 months... only NOW you want your main feature to work? Would have been a lot smarter to get your main features working in January/February. My main constructive criticism here is that you have left this WAY LATE.
Pretty hard to list periods which are not filled since there is no data to define what a period is. I might suggest a new table structure, but with a deadline of Friday....
How does the old saying go...why do something today that you can put off until tomorrow!!!
Just looking at this briefly the first thing that comes to mind is to use a Crosstab query. The reason for this is so that you can define all the periods in the day in the Columns headings so that when the query is run it will show the period even if there is no data for that period.
I'm assuming that there will be a set number of periods each day so that the report can be static and you only display one day at a time or per page of the report.
PS I remember college and I too have been in similar situations.