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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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.
 
Back
Top