Results 1 to 4 of 4
  1. #1
    DevilMaster18 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2010
    Location
    England
    Posts
    2

    Need help with room update query.

    Today, i was told to create a advanced query for my Hotel Database, but my tutor said one advanced query wasn't enough, she wanted more...



    She told me i need to make a query that shows the availability of the rooms after the customer's had checked out (Signed the Invoice).

    But, i've also got the 'Signed Invoice' check box which makes it so much more difficult, because if the 'Signed Invoice' isn't ticked it means the customer hasn't checked out so this leaves the room unavailable, but i do not know how to calculate the 'Room Availability'.

    I know i must calculate with 'Leaving Date', 'Room Booked' and 'Signed Invoice' (maybe 'Date Booked').

    Can anyone tell me a formula to solve my problem?

    PS - I don't know what formula to enter after (field on the right) 'Surname'' on design view or what formula to enter on any criteria fields. Also, sorry for being a novice as i'm relatively new to Access (well, not that new but not great at it). I do know how to do simple queries such as totalling up the cost, finding out 5% of employee's wages etc... but nothing advanced :S

    Please look at my images, it shows my Design view and Data sheet view.

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    if Signed Invoice Field is False then you room is cleared right. Then add this criteria to the Field in you query.

  3. #3
    DevilMaster18 is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2010
    Location
    England
    Posts
    2
    Quote Originally Posted by maximus View Post
    if Signed Invoice Field is False then you room is cleared right. Then add this criteria to the Field in you query.
    Add what criteria? Sorry, it's blank.

  4. #4
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    Well the criteria is False.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Update Query
    By Najeeb in forum Queries
    Replies: 1
    Last Post: 11-19-2015, 04:02 AM
  2. Update Query
    By vvasudev in forum Queries
    Replies: 0
    Last Post: 11-10-2009, 01:32 AM
  3. Update Query- selective update?
    By stephenaa5 in forum Queries
    Replies: 1
    Last Post: 10-29-2009, 11:15 AM
  4. Help with update query
    By weirdg in forum Queries
    Replies: 0
    Last Post: 09-03-2009, 04:21 AM
  5. Need help with an Update query ...
    By valkyry in forum Queries
    Replies: 0
    Last Post: 04-23-2007, 08:45 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums