Show All

Run a parameter query (ADP)

Note  The information in this topic applies only to a Microsoft Access project (.adp).

1. Do one of the following:
   • In the Database window, click Queries under Objects, click the parameter query you want to run, and then click Open on the database window toolbar.
   • In the Query Designer, Click Run to run the parameter query.

   Access shows the Enter Parameter Value dialog box for each parameter in the query.

2. Do one of the following for each parameter value you are prompted for:
   • To enter a parameter value, type the value.
   • To enter the default value, select <DEFAULT>.
   • To enter a Null value, select <NULL>.
   • To enter a zero-length or blank string, leave the box blank.

Note  You cannot run or create a view as a parameter query.