How to Create a Query in MS Access

Microsoft Access allows you to search and filter your database's tables in order to select the information you need based on certain parameters you set. These searches are called "queries," and they can be used in a variety of ways. Creating one for the first time, however, can be a bit challenging, and it may require some time before you can use them efficiently.

Difficulty: Moderate

Instructions

Things You'll Need:

• Microsoft Access
• A functioning database with data

1. Select the "Query" tab from the Access database screen. You can also select "Queries" from the "Object" menu.

2. Double click "Create query in design view." This will open the query options.

3. Select the table in which you want to search for data.

4. Choose the specific fields you want to search from the drop down menu that appears in the new screen.

5. In the area marked "Criteria," you can input the actual search criteria you want for each entry. You can right-click on the Criteria box in order to bring up a list of possible variables. You can customize as many fields as you want.

6. Save your query with the "Save" button in the top menu bar.

7. Double click the query you just created in the "Objects" window in order to test and run it.

Tips & Warnings

• You can have your query produce outputs in the form of reports or simple tables of information.

[faithcopeland]

on 9/6/2008 IM trying to learn access and i dont seem to see what the code is for the queries
more than or less than
i want to find paintngs within price less than 2000dkr
i tried >= 1000 AND <= 4000 etc but it give me an error back" mismatch expression "
can any one help me and maybe give me the correct codes for more than and less than etc
thanks
[e-mail]