Overflow message

[Guest]

Hello all

I receive an Overflow message when I try to run a crosstab query. The
strange thing is the query I am performing the crosstab off of runs fine and
other crosstab queries in the database with the same number of records run
fine. I do not know how to diagnose the error. Any suggestions?

Thanks in advance

 

[Douglas J. Steele]

Sounds as though your data type is too small to hold the sum of the values.

If your fields are Integer, try changing them to Long Integers.