Creating a variable
-
Open the Database Variable window in one of the following ways:
- On the ribbon, from the Data tab, click . group on the
- In classic view, click Database menu > Formulas > Variables.
-
Click [Add] to open the Adding Database Variable window.
-
Complete the fields. You can use [Copy] and [Prefill] for this purpose. At a minimum, you need to enter a descriptive name (up to 70 characters) for the variable in the Variable field.
The remaining fields are optional—you can complete some or all of them if you want.
For more information, click on the title bar of the window, and then click a field or button.
-
When you finish setting up the variable, click [OK] to save it.
-
Set up additional variables in the same manner. When you finish, click [Close].