Add Other Field to Query

A variety of other custom formats can be added. Available formats depend on the format of the field.

1. From the Tools menu, select the Queries... option.

   The Queries form is displayed.
   

2. Select the module and record area, and either create a new query, or modify an existing query.

   Information on creating or modifying a query is available in Create New Query and Modify Query.

3. In the Query Designer form, Fields section, highlight the field name in the left box, press .

   The Other field is added. The Additional Query Functions form is displayed.

4. Select a function, then press OK.

   The selected function is added to the query.