
Help with DCOUNT overflow problem
Quote:
> Do you insert ? format(0/0,'percent') somewhere in the
> code to fix the problem? Is this a fix or a question?
It's a way of demonstrating the error: type that command into the Immediate
Window and you'll get the overflow error. I think you are getting the
overflow error because you are dividing by zero.
Quote:
> I'm
> using this procedure to get daily data for a month for
> graphs in Excel. A single SQL query? I don't see any
> other way, given the amount of data being calculated at
> 79,000 records.
Given that amount of data I'd be breaking rocks trying to do it a single
query... but the logic is too obscure for me to see how it might be done.
"If it's not broken, then don't fix it" is a good rule for life, but it
also appears that it is broken.
Quote:
> This type of query structure runs stats
> very fast and is suitable for what needs to be done. The
> denominator DCount source may be the problem here causing
> the overflow error.
Yes, that's what I said above. Prolly the best thing is to get the two
DCounts separately into two variables and then check before doing the
division.
BoL
Tim F