Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 29th, 2011

 

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.