What would cause an overflow error when you run a crosstab query?

[Guest_imported]

I am referencing a relatively small select query with 8400 records. The crosstab query will convert the data to read with months as the column heading and customer and year as row headings.

 

[Databaseguy]

Check to make sure there are no formulas. Specifically, divide by Zero. Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[jebry]

Hi!

You also may want to check, if your crosstab is summing or multiplying, that no numbers are getting too big for the data type, like an integer.

hth
Jeff Bridgham