Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2006
    Posts
    3

    Unanswered: Hotel reservations DB HELP PLEASE!!

    hi,
    i am looking for fast help on a database due in for a uni assignment tommorow, i am making a hotel reservation system, i have designed the basic tables but i cant make a form where it tells me the hotel is full, what rooms are available, can anyone help?? pleassssssseee, thanks

    i am on msn right now if you can,
    thanks again
    Bobby

  2. #2
    Join Date
    Apr 2006
    Posts
    3
    anyone have any ideas or done somethin similar? im still online...thanks

  3. #3
    Join Date
    Feb 2004
    Location
    Wales
    Posts
    343
    Hi
    First off YOU LEFT IT LATE TO ASK FOR HELP FOR UNI...
    2nd. Your course tutor will be well impressed if they were aware that you were seeking help to complete an assignment here

    However, Try querying your reservation table that should be showing the dates of occupence and(arrive and leave dates) leave dates will nbormally be date and ie 10 am then housekeeping until 3pm

    That will show room availability as emty rooms wil NOT have a new arrivel date - its the quickest opetion for you to get it done
    Gareth

  4. #4
    Join Date
    Apr 2006
    Posts
    3
    is there any chance you can talk me through how to do it?
    i can email u the db if you want?

Posting Permissions

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