Sum of formula on Microsoft Acces?

Question

Need to save sub total one column in Microsoft access. Some one guides me where I put sum formula on my access data base fine.

Answer 1

The SQL would look like this:

SELECT myField, SUM([myField])

FROM myTable