Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2009
    Posts
    3

    Unanswered: How do i make a timetable report?

    Hi

    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.

    RapidShare: Easy Filehosting

    That should hopefully work, it can only be downloaded 10 times so make sure you have saved it.

    The password is teacher

    Any constructive criticism is appreciated

    I'm not very computer literate, so if you are able to help please remember this.

    Thankyou

    Andy

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    When were you given the assignment?

    Friday seems like a very short timeline to produce a working system from scratch for a student.

    Where are you stuck?

    What's your table structure?

    Why not upload a zipped version of your db here so you are not limited to 10 downloads?

    Clearly, I have nothing but questions!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Apr 2009
    Posts
    3
    ICTBookingSystem.zip
    Click image for larger version. 

Name:	ScreenHunter_17 Mar. 24 14.44.jpg 
Views:	296 
Size:	48.1 KB 
ID:	9495


    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.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    ... 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....
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Jul 2004
    Location
    South Dakota
    Posts
    267
    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.

    Good luck.

    C

    PS I remember college and I too have been in similar situations.

  6. #6
    Join Date
    Apr 2009
    Posts
    3
    Thanks for the replys.

    I'd tried making the main feature for a couple of months, and its just this week i'd try posting on a forum in desperation.

    I've managed to do it today, using a cross tab query, so I can relax for four days

    Thanks again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •