Using the Add Parameter dialog (setparm)

To add a parameter to your query, select Parameters > Add Parameter.

This can be used to add one of the following commands to your query:

• a setparm statement (set a parameter to a value)
• a queryparm statement (prompt the user to enter the value)

The example below is for setparm. See the next topic for queryparm.

Special Value

You can set the parameter to a variety of special values:

In the following example, the parameter will be set to the last day of the current month.