Defining Parameters in the SQL Statement Builder

You can define a parameter by entering the name of the parameter in the Parameter field of the Specify Selected Item Wizard or the Specify Criterion Wizard. When you enter a name, the Statement Builder adds a question mark to the end of the name and encloses the entire string in curly brackets. For example, the parameter temperature becomes {temperature?}.

You also have the option to select a data type for the parameter. The data type determines the kind of data the parameter can hold. By default, the data type is set to char; however, you can select int, date, num, or char as the type of database column.

When you define a parameter in the SQL Statement Builder, you can specify a default value for the parameter from the Parameters tab.

NOTE: Parameter names must be unique; you cannot create multiple parameters with the same name.

See Also

What are Parameters?

Using Existing Parameters

Creating Parameters in an Edited SQL Statement