Sum Problem

[lsearcey]

I'm new to access and am having trouble adding a field that contains rate costs. I ran the query and put in the totals area sum put it doesn't add it . The field is called "access cost" but it just changes the name of the field to "sum of access cost" but lists each one instead of totaling them. What can I try ti fix it. Thanks

 

[Joe4]

You cannot do a total sum in a query like that -- it only sums up the values for that row of data. So if you are doing a sum on one field, the result will be the same as the value in that field. Normal queries are not good for capturing Grand Totals or Counts.

If you just want a total line, you can use Grouping in your query to group all the records you want, and then select Sum under the grouping option.

If your final intention is to display the total on a Form or Report, wait and do the totals there in a Group or Report Footer.