Working with standard databases > Building and modifying a standard database > Formulas > Creating a variable

Learn more

Creating a variable

Open the 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 > Formulas > Variables.
Click [Add].
Complete the fields. You can use [Copy] and [Prefill] for this purpose. At a minimum, you need to enter a descriptive name (up to 20 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 $image\windhlp.gif$ 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].