What is the way for summing up a column in a table in Microsoft Access database?

Questions by scott   answers by scott

Showing Answers 1 - 3 of 3 Answers

You can create a query using SUM function to calculate the sum of a column.

SELECT SUM([Column_Name]) FROM [Table_Name]

or

In reports You can place a field in footer with control source as "=SUM([Column_Name])" which will calculate the sum of the column.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions