Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2010
    Posts
    14

    Unanswered: Trying to list rooms vacant for hotel

    I have a query set up to try to find rooms that are not booked - I have just added into the bookings a field (booked) which is yes/no in the hope that I can list all the free rooms - the query asks for the arrival date and the departure date but no luck on the rooms.

    pic of tables - this is for a school project
    thanks
    Attached Thumbnails Attached Thumbnails hotel.jpg  

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,423
    Provided Answers: 8
    Been there done that
    You need to right a query and a function that looks at the in date outdated and today date if the today date between in date and out date then that unit is booked
    As I have written my own booking program for my parents about 5 years If you want help buzzy me
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Sep 2010
    Posts
    14
    Hi,

    thanks for your rely - just tried it not sure if fully correct (my end) - comes up with error - have screenshot of the code in place and have changed my fields to Adate and Ldate and added todate into the bookings table. when i run the query comes up with error -

    would be grateful if you could have a quick look over.
    regards

    David
    Attached Thumbnails Attached Thumbnails code error.jpg   query.jpg  

Tags for this Thread

Posting Permissions

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