calculating totals

[Rugman]

Hi folks,

I would like to add up all the records in a field to get a grand total. Can I run a query to do this? I've tried the Totals button, but doing this is just summing the individual records, not all of the together.

Thanks for any help you can suggest to this Access virgin.

 

[Peter Reid]

Hi folks,

I would like to add up all the records in a field to get a grand total. Can I run a query to do this? I've tried the Totals button, but doing this is just summing the individual records, not all of the together.

Thanks for any help you can suggest to this Access virgin.

If you want a grant total for all records in your query, uncheck the 'Show' box underneath all fields EXCEPT the field you wish to 'Sum'

 

[Rugman]

Here's a screen shot

Hi, thanks, but that didn't seem to work.

What I want to do is add up all the numbers in the second column to get a grand total (see attachment).

Thanks

 

[boblarson]

If you want a total that isn't broken out by date, get rid of the date column to get the totals for each of the groups. That is why you are getting the totals you are getting. It is showing you the total for each group for each of the dates shown.

 

[Peter Reid]

Sorry, my bad.

I assume you've resolved the problem with boblarson's solution

 

[Rugman]

thanks

Yes, I've solved the problem. Seems to be working. Thanks again for your responses.