where availability = "vacant"
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.
This is strange (and suspicious). The answer history for this question, shows me as the author of a change I didn’t make…
Hi Carlos, we’re looking into your answer history question. I will let you know as soon as we figure out the issue.
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