Eliminate #Error from query results

[ChuckW]

Hi,

I have some calculated fields. A handful of the my values have an error in
them #Error. I want to actually exclude these results from showing. How do
I design a query that will kick these values out of my results?

Thanks,

 

[Jerry Whittle]

What's causing the #Error? Divide by zero? Adding null values? You need to
track down the culprit then fix it. Sometimes using something like the NZ
function on Null values works. Other times excluding the problem data in the
Where clause / criteria will fix it.