Sum won't Sum in Footer

[eepy]

I'm trying to put a Total in a Report Footer. I created a text box, went to Properties, clicked on the Data tab, typed =Sum([DRAW]) in the ControlSource space, and closed it. When I went to view the report, it wouldn't open, and I got an error message that said "The Microsoft Jet database engine could not execute the SQL statement because it contains a field that has an invalid data type." I have no idea what this means. Does anyone have any idea what I'm doing wrong?? I'm really tired of adding this list of numbers up every day

 

[KenHigg]

Did you mean to do some kind of count()? Is [DRAW] a string datatype?

kh

 

[eepy]

I think I want a Sum, not a Count. I don't know what a "string datatype" is.

I work in the circulation department of a newspaper, and I handle the Newspapers in Education program. "Draw" is a field in which I enter the number of newspapers going to each classroom. We run a report each day that lists the classrooms, the routes they're on, the draws, etc. We need a total number of newspapers (a total of the draws) at the end of the report.

Does that make any sense?

 

[proben930]

In your table, [draw] should be of the type "Number", not "text"

 

[eepy]

In your table, [draw] should be of the type "Number", not "text"

OMG!! It worked!

Thank you! Thank you! Thank you!