To parameterize an SQL statement, insert brackets wherever a variable is required. Between the brackets, you may formulate a prompt which appears in the dialog box where the text for the variable part of the SQL statement is to be entered. One SQL statement can have multiple parameters. They are retained when saving the SQL statement. If you want the columns Product ID and Price Per Unit from the table Products to remain variable, you can set the following parameters for the selection criteria:
