Creating a Parameter Query

1. Open your database in the usual way.

2. Go to the Queries tab and select New.

3. Select Design View and click OK.

4. Click Add to add your database to the query.

5. Click the Close button.

6. Either drag and drop fields from the field list box, or click in the field 'cell' and select a field from the drop-down menu.

7. Repeat for each field ...

8. In the Criteria: cell for the field you want to search on type in the Parameter label enclosed in square brackets. In this example "Enter SURNAME" is used. Any word, or phrase could be used.

9. Go to Query/Parameters...

10. In the Parameter list box enter the label used to identify the parameter. The label has to be exactly the same as the label you entered in the criteria cell in the previous step. Set the Data Type using the drop-down menu and click OK.

11. Close the Query Design window by clicking in the close box (the cross at the top-right of the window). Access will ask you to enter a name for the query you just created. Type in something meaningful and click OK.

12. Your new query will be listed in the query window.

13. Double-click your new query, or highlight it and select Open.

14. A 'pop-up' dialogue window will appear prompting you for a search parameter. Enter the search condition and press OK.

15. Access will 'query' the database and present the results as below ...

| Previous Page | Menu | Next Page | Home Page |