How to Create a Parameter Query in Access 2003

Queries help you to quickly look up information on an Access 2003 document. There are many different types of Queries. When you are looking for information that meets specific criteria then you want to create a Parameter Query in Access 2003.

Difficulty: Moderate

Instructions

Things You'll Need:

• Computer with Access 2003

1. Click the “Queries” button. This is located on the “Objects” list in the Database window.

2. Create a Query. Double-click the “Create Query” icon.

3. Pick your fields. Select the table with the fields you want. Then click the “Add” button. Click the "Close" button. This will show your table.

4. Choose your field names. Double-click on the field names you desire.

5. Click the “View” button to see the results on the datasheet.

6. Go to “Design View.” In the windows menu, choose “Query” then “Parameters.”

7. Choose a name. Type in a name for the Parameters and pick the Data type.

8. When finished click “OK” to close the “Query Parameters” box.

Tips & Warnings

• Parameter Queries should be used when you want data from a specific place, like a certain month or week.
• Be sure to save your work.
• Using a Parameter Query limits your information. If you need a broader range of data, you may want to use a different query.

[cristine1953]

on 10/29/2009 I have a cross tab query which I need to add 1 parameter - the user should be able to enter any date and have the result be all the open & closed defects for the date entered in the parameter dialog box.

from the xtab query above my team also wants to be able to select a date range to see the opened & closed defects between the dates entered into the parameters dialog box.