This interactive demo was created free with Storylane in 8 minutes. Create your own demo
How to Use Sum Function MS Access
The Sum function in Microsoft Access is used to calculate the total of numeric values in a field. It is often used in queries, forms, reports, and even VBA to summarize data. Here’s how to do it:
Go to the 'Create' tab.
Select the 'Query Design' button.
Add the table containing the field you want to count by clicking the 'Add Selected Tables'.
Drag the desired field into the query grid.
Click the 'Totals' button in the ribbon (Σ) symbol.
In the 'Total' row for the field, select 'Sum' from the dropdown.
Run the query by clicking the 'Run' button.
By following these steps, you can use the sum function easily in MS Access.
