[AccessD] Sum() returns #NUM!

Hi All,

Access 2000 (No SPs) ADP FE & SQL Server 7.0 BE

I created a stored procedure to return a recordset. One of the fields in the
record set is an integer value.
I wanted to show the sum of this integer field in the report header by
adding a textbox and setting the control value to =Sum([Total])

So far so good. My problem is sometimes the sum value in the report header
shows the true value and other times it return #NUM!.
It almost seems to be related to the number of records that are return, i.e.
if the number of records reaches a certain number the Sum function fails.

I am also trying to find out what type of value is returned by the Sum
function. Is it a variant? Integer? I could not find an answer on the MSKB.
Maybe Sum can only calculate to a certain value...I don't know...

Any suggestions?

Thanks!
Joe R.




This electronic transmission is strictly confidential to TNCO, Inc. and
intended solely for the addressee. It may contain information which is
covered by legal, professional, or other privileges. If you are not the
intended addressee, or someone authorized by the intended addressee to
receive transmissions on behalf of the addressee, you must not retain,
disclose in any form, copy, or take any action in reliance on this
transmission. If you have received this transmission in error, please notify
the sender as soon as possible and destroy this message. While TNCO, Inc.
uses virus protection, the recipient should check this email and any
attachments for the presence of viruses. TNCO, Inc. accepts no liability for
any damage caused by any virus transmitted by this email.