Creating a variable

  1. Open the Database Variable window in one of the following ways:

    • On the ribbon, from the Calculations group on the Data tab, click Variables.
    • In classic view, click Database menu > FormulasVariables.
  2. Click [Add] to open the Adding Database Variable window.

  3. 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 the Help icon available on the ribbon on the title bar of the window, and then click a field or button.

  4. When you finish setting up the variable, click [OK] to save it.

  5. Set up additional variables in the same manner. When you finish, click [Close].