Home > IT Answers > Microsoft Windows > Hotel database (Rooms availability) using Access 2007
Black0ice
5 pts.
 Hotel database (Rooms availability) using Access 2007
Access 2007, Database programming, Microsoft Access, Microsoft Access 2007
Hi there... I'm working on hotel database (Access 2007) I have a table named Rooms There are 3 fields in it Room ID, Room type, availavility how can I make Access shows the vacant rooms which are not related to any guest?

Software/Hardware used:
ASKED: November 22, 2008  1:55 PM
UPDATED: November 24, 2008  6:58 PM
RELATED QUESTIONS
Answer Wiki:
If I understand well, that would be with a query like this: 
select *
from rooms
where availability = "vacant"
As we don't know the data types of the fields, the condition in the where clause could need to be changed. If that's not what you meant, please provide more information in the discuss section.
Last Wiki Answer Submitted:  August 8, 2012  9:05 am  by  TomLiotta   108,155 pts.
All Answer Wiki Contributors:  TomLiotta   108,155 pts. , alex1987   40 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Without many details about the table info & other critteria – I am not sure how to provide help. The simplest way (without any programming) in Access 2007 will be:
Go to Create .. then Select Query Design (under Other) … Select the table (Add) & then close.
Click on the fields that you want to display. Under criteria .. . Type “Vacant” – if that is the field value if it is not occupied. Hopefully you will see the result displayed.
Try to read any basic Access programming text books.

SbElectric
 2,510 pts.
 

This is strange (and suspicious).  The answer history for this question, shows me as the author of a change I didn’t make…

carlosdl
 63,535 pts.
 

Hi Carlos, we’re looking into your answer history question. I will let you know as soon as we figure out the issue. 

Ben Rubenstein
 2,060 pts.
 

An ‘Answer’ from “carlosdl” showed up sometime around midnight PDT. That seemed very uncharacteristic, so I looked to see what he had to say. I did some cleanup and left it with what seemed to be as good as it was going to get. It took a few tries before anything worked at all. Answer History hasn’t been working reliably since the code changes a few weeks ago. Tom

TomLiotta
 108,155 pts.