>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

You might make an aggregate query with SUM() and see if you get #error. If so, you might have numbers it doesn't like (maybe handling of nulls, which always screws me up). If not, it could be a syntax problem, perhaps confusing the name of the field with the name of a textbox object, or something. You could also make a quick and dirty imitation of your report using the Access report wizard and see if the syntax comes out the same.

Two Access fora I have used with some success are http://www.athree.com/ and http://www.helptalk.net/forums/access/ both of which will make you appreciate the UT a lot more. Those sites get maybe a quarter of the traffic of the UT, and it's mostly novices, as you would expect.