Learn more

Changing an existing formula table

Changing the conditions for a formula table

Changing the return values for a formula table

About formula tables

Creating a formula table

Tips for filling in the formula table

Formula Table window

Formula Tables command

Use this command (Data tab, or in classic view, Database menu) to create, edit, and test the individual formula tables in the standard database. A window opens so you can set up the conditional criteria for returning the correct value to a formula. Formula Tables is available only when a standard database is open. 

Tips:  

  • Edit Formula Table is available on a button or on the shortcut menu when you are working with formula tables in other windows.
  • Use the Options command if you want the Formula Table window to remain in add mode after you save each new record.