Count column in Query

[mattpfc]

Hi all,

Could somebody tell me if it is possible to created a column within a query that totals all numeric values within a certain column. I do not need to count the amount of rows I need to count the total of the column. e.g.column A has 10 rows and each row has the value of 2 then the total is 20.

Thanks in advance

 

[Bariloche]

matt,

Right of the top, I'd say "No." But, look at creating a report based on your query. That will be able to do what you want (if I understand correctly what you want). Keep in mind that Access is a database application and as such it can only do limited math. A report, or taking the data to Excel, should be the way to go. If you haven't any experience with Reports, try it. Its a good skill to have.


enjoy

 

[Russell Hauf]

Can you give an example of what you'd like to see?

 

[belzar]

I think you are saying you just need to sum a column. If so all you need to do is click the Totals button up on your toolbar while in query design view. It looks like an E. This will add a new option to your fields at the bottom of the window called Total. These should all default to Group By. Just go to the field you want to sum and change the Total option from Group By to Sum. The sum/sums you get will be based on the other fields you add to the query. For example, assume you have three fields called City, Hotel and Customers. If City and Hotel are marked as Group By while Customers is marked as Sum, you will get a resultset that sums up the number of Customers for each hotel while also listing the city for each Hotel. If you remove the Hotel field and run the query you will get a resultset that sums up the number of Customers for each City. I hope this helps.

Robert Hall
This message was edited by belzar on 2002-12-09 13:38
This message was edited by belzar on 2002-12-09 13:39