Can access calculate the sum of a column or row in a database table?

message from =?Utf-8?B?Unlhbg==?= on 21 May 2004
Hello, I have created a database and I have five columns for each category and about 50 rows of data below these catagories. I would like to be able to add the data from each catagories column is this possible with access. I would also like to create a graph from this data eventually for my webpage. THanks for any help or suggestions. Ryan
 
John Vinson replied to =?Utf-8?B?Unlhbg==?= on 21 May 2004
Yes; you can create a Totals query. Create a Query based on your table
and click the Greek Sigma icon (looks like a sideways M, or W). Change
the default Group By on the Totals row to Sum for these five fields.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
 

Archived message: Can access calculate the sum of a column or row in a database table? (MS Access Database)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.