Split Form Totals or Average etc for Datasheet

[wdrspens]

I have downloaded a very useful template from the Microsoft Template site to handle my accounts, and on the main Form, which is a split form, there is a most useful and helpful addition to the spreadsheet part of the form, that I do not seem to be able to replicate on the spreadsheet form of any split form that I design.
There is a line at the bottom where, under each column, I can click on a little drop down arrow, and, for numerical columns, can calculate the Sum, Average, Count, Maximum, Minimum, Standard Deviation, and Variance, and have it displayed for the records shown in that column, even following a filter on that or another column.
Under a text column the option is Count and under a Date column the options are Average, Count, Maximum and Minimum.
How can I replicate that very useful addition to the spreadsheet form?
Thanks
David

 

[wdrspens]

Problem solved (use of Microsoft Help Files )

In the Navigation pane, double-click your table. That opens it in Datasheet view automatically.

On the Home tab, in the Records group, click Totals. That shows the Totals row at the bottom of your datasheet.

 

[boblarson]

Thanks for posting back with your success and how you did it. Very few actually do but it may help someone else in the future.