Error on SUM( ) function

[Ram]

We converted Access 97 to 2002. One of the form has
details section and form footer with totals using
=SUM(Column1) function. Some times the total works fine
and some times display error. The message display on the
total field is #Error. Any ideas?

 

[GVaught]

Generally when this happens it is due to references not set correctly in the
2002 version that were set in the 97 version. The best way to ensure that
all your code is compatible with 2002 is to open the code editor window and
issue a Compile. This will generally alert you to improperly referenced
code. If all compiles well, then it may be a reference within a query that
is causing the problem.