Suming a counted field

[peters]

I am making a report from a query.

The query has been programed to count data based on certain categories. ( Based on Category, count the number of reports that fall into that category)

In my report, I have listed all the categories and the counted number as in the query.

However, I would like to add a sum box at the bottom to total the number of reports. I think the problem lies in because I am trying to sum a non-number field.

Any suggestions as to how I can get a total on this report???

 

[peters]

I have tried to change the query field to be formated as a general number field.

When I add my sum function, all I get is an #error.

Any ideas?

 

[Richie]

Where are you putting the calculated control.

 

[peters]

I have been trying to put in into the control source for the file. Is this wrong?

 

[Richie]

Is the control in the page or report footer?

 

[peters]

It is in the page footer.

 

[Richie]

This article explains what to do Article ID: Q132017

 

[peters]

Thanks Richie, that is exactly what I have been looking for.