I have a summary report based on CountOF fields (there are 10 CountOf fields, some text, some numbers) in a query. I cant seem to get a running total of the countOF fields which has the counts based on groups.

I've tried sum([Countoflastname]) but that is only producing an error. Any suggestions?

Can you post your Sql? It seems as if Countoflastname field may not be of a numeric data type. Maybe try

Sum(clng([CountofLastname])