How to Sort Records Using Multiple Criteria in Access 2003

Are you trying to sort records using multiple criteria in Access 2003? This can be a confusing step if you have not already tried it. With just a few short and simple steps this article will show you how to sort records using multiple criteria in Access 2003 with ease.

Things You'll Need

• Computer
• Access 2003

Instructions

1. Open Access. Do this by clicking on the "Start" button that is located on the bottom left of your screen. Now, choose "All Programs". From the list available, choose "Microsoft Access".

2. Load the database(s) you wish to search through so that they are displayed in the main user interface of the program.

3. Decide by which criteria you wish to sort the records. Now, locate the criteria cell. This will be at the top region of the user interface.

4. Using the "AND" and "OR" functions of Access 2003 connect the criteria in the cell and push enter. An example of two criteria would be "apples AND oranges".

5. Consider the results of your sorting and if necessary complete another search. This should allow you to sort records in Access 2003 with efficiency.

Tips & Warnings

• If two criteria are not yielding the results you desire, try using synonyms of the words for different results.

• The "AND" and "OR" functions are case sensitive. Always capitalize them or the computer may interpret your search as one criterion instead of two.

• Too many different search parameters can ruin its effectiveness.

• Remember to save frequently to ensure that your work does not get lost.