You may be prompted for a value or a range of values.
· For a value, enter a single value.
· For a range of values, enter a lower limit value and an upper limit value. All the values that fall between are automatically selected for the parameter. You can also use the associated check boxes to specify whether you want to include the lower limit or upper limit values in the range, or whether you want to set the range with no lower limit or upper limit.
Single selection and multiple selections
You may be allowed to make a single selection of a value or a range of values.
· For a single selection, you can enter only one value or one range of values.
· For multiple selections, you can enter more than one value or one range. In some cases, you can enter multiple selections of both values and ranges, depending on the instructions you see for that parameter.
Set the Value to Null
Null means no value exists. For example, in a database table with two fields "Company Name" and "Address," if a record has a company name, but the address is missing, the Address field value for this record is Null.
If you select the Set the Value to Null check box, you have actually selected Null but nothing else for the parameter.
Specified Format
In some cases you will be asked to enter a value in a specified format, such as "(201)332-1134." Do so by following the example provided in the prompting dialog box.
