Queries that prompt
You can define a query that prompts you to enter the values for the search conditions when you run the query. This is useful if you have a standard query that you would like to repeat for different values. It is also possible to use this type of query to provide the source data for another query.
Example of a query with parameterized conditions
When you run a query with conditions defined like this:
You will be prompted to enter a value for each field set to the @ character:
To run the query, you must enter a value for all the parameterized conditions.
Setting up a parameterized query
- @ instead of the actual value.
- @ followed by a default value. For example, you might enter @Yes as the default for a Yes/No field.
You will enter the actual value when you run the query. Depending on the operator you used, you may need to enter @ in the Value 2 column as well.
You can use the following parameters:
|There will be a prompt for this field value when the query is run.
|There will be a prompt for this field value when the query is run. If you specify a default value, there will be no user input required to specify that value (apart from confirming it). For example '@BMW' specifies 'BMW' by default.