Anonymous
Anonymous Asked in Cars &Transportation · 2 weeks ago

How do I sum a field in an Access report?

Contents
  1. How do you sum a field in access?
  2. How do I add a subtotal to a report in Access?
Add a total or other aggregate in Layout view In the Navigation Pane, right-click the report and then click Layout View. Click the field you want to summarize. . On the Design tab, in the Grouping & Totals group, click Totals. Click the type of aggregate that you want to add for the field.


How do you sum a field in access?

On the Home tab, in the Records group, click Totals. A new Total row appears in your datasheet. In the Total row, click the cell in the field that you want to sum, and then select Sum from the list.

How do I add a subtotal to a report in Access?

Click "with no totals" and select the check boxes that determine the location of your subtotals. Select "Show Grand Total" to create a totals expression for the whole report. Select "Show Subtotal in Group Header" or "Show Subtotal in Group Footer" to place the subtotal expression on your report.

Related Questions

Relevance
Write us your question, the answer will be received in 24 hours