Eliminate #Error from query results

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

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,
 
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.
 
Back
Top