Totals Row

Another new feature for datasheets in the Totals Row. At the bottom of any datasheet view, one can opt to show a row that will do a number of canned aggregation formulas applied to each column, independently. You can see it in action here, where the # of items is shown as "8".

Depending on the type of the column, different aggregations are allowed. For text fields, only a count of the fields in that column that are not empty can be shown. For numeric columns, one can do counts, sum, average, maximum, mininum, standard deviation and variance.

An interesting aspect is that the totals row is pinned to the bottom of the datasheet view (right above the Record Navigator), so you will be able to see it regardless of what data is being shown. There is no need to scroll up and down to see what the aggregation is showing.

Comments

• Anonymous
  June 29, 2006
  This is a great new feature! Although I often complain that the Access team is trying to re-invent Excel, column summations is one feature that does not impact the database's design, and benefits both users and developers. People have been asking for something like this for a long time.
  Also, keeping the totals row in sight is very considerate of users.
  (You know that people are going to want the totals row at the TOP of the datasheet next, of course!)