Yeah, I know this isn't Fox, but I don't know any Access people. Maybe someone here knows...

I've got a field, "extprc" in the detail line of a report. In the page footer, I need a sum of that. So I made a textbox with a controlsource of =SUM([extprc]). On the report, it just says #error. I don't know what the error is. The field type is currency, so it should be summable.

Any ideas?

Thanks,

Michelle