Data Access Page Filtered Totals

B

Bruce

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help creating a search form in Access XP 0
Data Access Page Filtered Totals 0
totaling in a filtered form 2
Using DSUM to get running total on a filtered form 0
Page numbering with Merged Document and IF statements 1
filter result- total row numbers varies 1
Adding data to MS Access from csv file 0
How do I clear a form? 0

Top