Question

how can you find the sum of values in a field in a table ?​

Answer 1

Answer:

Make sure that your query is open in Datasheet view. To do so, right-click the document tab for the query and click Datasheet View. ...

On the Home tab, in the Records group, click Totals. ...

In the Total row, click the cell in the field that you want to sum, and then select Sum from the list.