Creating a query which uses multiple standards for a arena is like owning a filter on your own query final results. For example, in case you have a stand that contains complete addresses of your friends, you'll be able to run a dilemma that will present brief data for those who are now living in New York, and for those who have a home in New York and whose name starts with a letter "B".

1. Create a query in the common way. While using example presented above, you should include the fields "Surname" and "City". (Discover "How to Create a Uncomplicated Query inside microsoft access 2007.")
2. From this access 2007 database screen, in Concern view, select the query, then click on Pattern.
3. The query starts in Style and design view. While in the Surname industry, click in the Criteria word box.
4. To find friends as their name starts off with "B," type in Like "B*" in the Criteria word box. Media Enter.
5. In the standards text field for the Area field, type in "New York." Press Enter.
6. Switch to Datasheet watch. You will see an index of all buddies living in New York whose brand begins with the particular letter "B".