How to Create a Microsoft Access Query Making use of Multiple Criteria in One Area

Creating a query that uses multiple considerations for a subject is like using a filter on your own query success. For example, should you have a table that contains comprehensive addresses coming from all your friends, you possibly can run a problem that will screen brief data for those who are now living in New York, or for those who are now living in New York plus whose surname starts with this letter "B".

1. Create a question in the typical way. While using example provided above, you will include the fields "Surname" and "City". (View "How to Create a Very simple Query throughout microsoft access 2007.")
2. From a access 2007 database home window, in Concern view, find the query, then click on Pattern.
3. The query unwraps in Style and design view. From the Surname field, click inside the Criteria text box.
4. To look for friends whose name gets underway with "B," enter into Like "B*" inside Criteria text box. Click Enter.
5. In the Criteria text container for the Location field, enter "New York.In Press Get into.
6. Switch to Datasheet watch. You will see a long list of all close friends living in Nyc whose identity begins with the actual letter "B".