An example of query-by-example in Access
Query By Example is delightfully simple, but it still has its pitfalls. For example, if you fail to tick the UnitedNationsMember field in this Access query, you'll get no matches. That's because you'd be asking for records where the country is not a member of the United Nations but is a member of the UN Security Council.
| back to databasics |