Creating a query with an And condition allows you to search for information in your database with multiple criteria. Here's how:
1. Click on the Create ribbon at the top of the Access window.
2. Click on Query Design.
3. Choose the table or query you would like to search (see the picture below).
4. Close the Show Table once you've selected your table or query.
It's as easy as that! You can also create queries with Or conditions to bring in information that is different from one another at the same time (for example, people who are in the Sales Department or a Clerk). For demonstrations on how to use Access, check out our courses on Access 2010 Introduction, Advanced, and New Features, and be sure to take advantage of the first 3 FREE previews of each.
1. Click on the Create ribbon at the top of the Access window.
2. Click on Query Design.
3. Choose the table or query you would like to search (see the picture below).
4. Close the Show Table once you've selected your table or query.
5. Choose what you want to place in the query grid at the bottom of the screen. You can select, drag, and drop individual categories from the table you've selected, or you can double click on the table name (in the picture below, EmployeeInfo) to highlight all the fields in the table and drag them down to the query grid. Simply drag the highlighted information to the first grid column.
6. Fill in your criteria. By filling in criteria along the same criteria line, you are asking an And condition. In the example below, the query will pull results for a person who is both in the Sales Department and a Clerk.
