Creating a query that utilizes multiple requirements for a field is like managing a filter in your query benefits. For example, for those who have a table that contains finish addresses of most your friends, you may run a query that will present brief data for those who have a home in New York, or those who are in New York plus whose name starts with the actual letter "B".

1. Create a query in the normal way. Making use of the example supplied above, you'll include the areas "Surname" and "City". (View "How to Create a Basic Query inside microsoft access 2007.")
2. From a access 2007 database windows, in Dilemma view, find the query, after that click on Style and design.
3. The query starts up in Layout view. Inside the Surname field, click inside the Criteria wording box.
4. To search for friends whoever name depends on "B," type in Like "B*" in the Criteria word box. Media Enter.
5. In the factors text box for the Metropolis field, enter in "New York.In Press Enter in.
6. Switch to Datasheet look at. You will see an index of all buddies living in Ny whose label begins with a letter "B".