Access 2010: Add a “Total” Row To Apply Mathematical Functions Quickly

Access 2010 allows user to easily include Totals field which includes a list of mathematical function to evaluate Sum and Average along with Standard Deviation whilst letting user count total number in field and find out max and min number. In this post we will how to add a Totals field.

For adding a Total row in table, open the database table and head over to Home tab, from Records group, click Totals.

450d1274347811-add-total-row-applying-different-functions-quickly-


It will add a row at the bottom of the table, allowing you to apply list of functions, as shown below.

451d1274347812-add-total-row-applying-different-functions-quickly-

Select the function to evaluate field values instantly.

449d1274347809-add-total-row-applying-different-functions-quickly-

Advertisement
  • prog

    thank you soooo much for this

  • prog

    this is very helpful…thank you sooo much….

  • black

    how will it reflects on my query?