How to Produce a Microsoft Access Query Making use of Multiple Standards in One Industry

Creating a query which uses multiple conditions for a subject is like managing a filter with your query benefits. For example, for those who have a stand that contains total addresses of the your friends, you'll be able to run a question that will screen brief info for those who live in New York, or for those who are in New York in addition to whose name starts with this letter "B".

1. Create a query in the normal way. Using the example given above, you will include the fields "Surname" and "City". (Notice "How to Create a Simple Query inside microsoft access 2007.")


2. From a access 2007 database eye-port, in Query view, pick the query, and then click on Design.


3. The query starts in Design and style view. From the Surname area, click while in the Criteria text message box.


4. To look for friends in whose name depends on "B," enter Like "B*" inside Criteria text box. Press Enter.


5. In the Criteria text pack for the Location field, enter in "New York.Inch Press Type in.


6. Switch to Datasheet view. You will see a list of all pals living in New york city whose identify begins with this letter "B".