Summing calculated fields in access

[mhegazy]

I have generated an access report that shows the process comments for the different locations we have in the organization. What I need to do is to count the total number of comments we have per day for the daily report I generated.

I used a textbox under the gourp footer with the expresson "=Count([Comment])".
It worked fine to get the count of teh comments under each goroup.

I need to gererate a grand total for the report summing the values of the textbox with the above expression.

Also, is there a way to count the text fields one time as a grand total for the report.

Thanks in advance.

[Seth Schrock]

If you put the same thing in the report footer, it should count the total for the report. I guess I'm not totally clear the difference between generating a grand total for the report and counting the text fields.

[mhegazy]

Seth,

Would you please explain a litte bit more?

Thanks,
mhegazy

[Seth Schrock]

You said you had =Count([Comment]) in the group footer. Put that in the report footer as well. That will give you the total count.

[mhegazy]

Thanks Seth

It works fine