Runtime Error 6. Overflow 1

[dawnd3]

I am getting a run-time error when I run a report that is calculating data from 150,000 records. "Runtime Error 6. Overflow" Then if I click debug it highlights code for a DCount function. My thought, after reading help, is that the DCount Function has a limit to how high the result can be based on the fact that it is an integer. And that the number that the DCount is coming up with is too large and causes the runtime error. I guess I am wondering if anyone knows about this and knows how it can be worked around.

Thank you,

Dawn

http://www.calliopeconsulting.net

 

[Craig0201]

Dawn,

Have you checked the variable that the DCount is returning into? Is it an integer? If so, try switching to a Long. This has a much greater allowed range.

Craig

 

[dawnd3]

Craig, you're a friggin genius! Thank you.

I love TEK TIPS!

Dawn

http://www.calliopeconsulting.net