Creating a custom measure

As you create a query, you might find that you want to use a formula that does not exist in the database. You can use the existing measures to define formulas to meet these needs. Formulas that you create are called custom measures.

If you create a custom measure when its database is attached read/write, then your custom measure is available to all users who attach that database. If you create a custom measure when its database is attached read-only, then your custom measure is available only to you.

To create a new custom measure:
  1. From the Express Query dialog box, choose Custom Measures.

  2. In the Custom Measures dialog box, select the database that you want to use.

  3. Choose the New button. The name of the action that is displayed on the title bar is New.

  4. Complete the Custom Measures - Action dialog box.

  5. Choose OK to return to the Custom Measures dialog box.

  6. Choose Close.

See also

Using the Express data source

About custom measures