#### To create a running total in a list

1. To get started, create a report using the sample database `Xtreme.mdb` located in the `File Data Sources` folder of the Data Explorer dialog box. Link the Customers and Orders tables, and then place the following fields from left to right in the Details section:

    {customer.CUSTOMER NAME}
    {orders.ORDER ID}
    {orders.ORDER AMOUNT}

1. On the `Insert` menu, click `Running Total Field`.

   The Field Explorer dialog box appears.

2. Double-click `Running Total Fields`.

   The Create Running Total Field dialog box appears.

3. Enter the name "TotalOrders" in the `Running Total Name` box.
4. Highlight {orders.ORDER AMOUNT} in the `Available Tables and Fields` box, and use the first arrow button to move it over to the `Field to summarize` box.
5. Select `sum` from the `Type of summary` list.
6. In the `Evaluate` section of the dialog box, click `On change of field`, and select {orders.ORDER ID} as the `On change of` field.

   The running total will execute each time this field changes.

7. In the `Reset` section of the dialog box, click `Never` (this gives you a running total that never resets; that is, the running total continues throughout the report).
8. Click `OK` to save the running total field.

   The program returns you to the Field Explorer dialog box.

9. Insert the running total field in the Details section of the report, just to the right of {orders.ORDER AMOUNT}.

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com