Hotel database (Rooms availability) using Access 2007

5 pts.
Tags:
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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Black0ice
    [...] Original unknown [...]
    0 pointsBadges:
    report
  • SbElectric
    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.
    2,540 pointsBadges:
    report
  • carlosdl
    This is strange (and suspicious).  The answer history for this question, shows me as the author of a change I didn't make...
    69,175 pointsBadges:
    report
  • Ben Rubenstein
    Hi Carlos, we're looking into your answer history question. I will let you know as soon as we figure out the issue. 
    5,815 pointsBadges:
    report
  • TomLiotta
    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
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following