How to: Create Queries with Unnamed Parameters
You can create a query with an unnamed parameter by specifying a question mark (?) as a placeholder for a literal value. Query and View Designer will give it a temporary name. You can specify as many unnamed parameters in the query as you need.
Note
If you are using multiple parameters, you can use named parameters to help you distinguish them. For details, see How to: Create Queries with Named Parameters.
When you run the query in the Query and View Designer, the Query Parameters Dialog Box is displayed with the temporary name.
Note
Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Visual Studio Settings.
To specify an unnamed parameter
Add the columns or expressions that you want to search to the Criteria pane. If you do not want the search columns or expressions to appear in the query output, remove them as output columns.
Locate the row containing the data column or expression to search, and then in the Filter grid column, enter a question mark (?).
By default, the Query and View Designer adds the "=" operator. However, you can edit the cell to substitute ">", "<", or any other SQL comparison operator.
See Also
Tasks
How to: Create Queries with Named Parameters