Data Access Page and Filtered Totals

Data Access Page and Filtered Totals

Post by Bruc » Sat, 30 Aug 2003 21:17:29


Hi all, not exactly sure where to ask this, but here goes:
I've created a Data Access page from a Form. The Form had
Averages and Totals. On the Form, when I choose filter,
the Avgs and Totals are only for the displayed filtered
records. When I created the Data Access Page, the Avgs &
Totals were not carried over from the Form. So I manually
added the these fields by clicking the Field I wanted to
Avg or Total on, then choose AutoSum from the toolbar for
the calculated field.
This seems to work fine until I choose to Filter. The Data
Access page's totals do not filter out only the Displayed
records, i.e., it is totaled for all original records.
Can the Avg & Totals be changed to recognize only the
Filtered records?

Thanks
Bruce