Sum function in Access Project Form gives #error

M

Mark

Access 2003 Project / Windows XP SP1 / SQL Server 2000

For some reason I keep getting error messages on summed columns. I am
basically creating a form from a stored procedure. I then add a cell to the
footer with the following formula "=sum([coamt])". On some forms it adds
correctly, but when the form is automatically or manually refreshed it turns
to "#error" and on other forms I get "#error" immediately.

Any help would be appreciated,
 
Top