Summing column that includes #Error values

  • Thread starter Thread starter will
  • Start date Start date
W

will

I have asked this before but it's come back to haunt me. I have a
calculated value column in a query that contains some #Error values. This
generates an error when attempting to run a query which is a sum on that
column.

How can I get around this - ie. make it ignore the #Error values when
summing stuff?
 
will said:
I have asked this before but it's come back to haunt me. I have a
calculated value column in a query that contains some #Error values. This
generates an error when attempting to run a query which is a sum on that
column.

How can I get around this - ie. make it ignore the #Error values when
summing stuff?
Click to expand...


Deal with the source of of the #Error instead of trying to
fidge it later.

You can test for an error value by using the IsError
function. Possibly something like this will be useful:
IIf(IsError(field), 0, field)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing values where one is #Error doesn't work 3
Calculations in a Sum Query 2
Access #Error & Excel Pivot 0
including null values in a sum query (non-SQL programmer) 2
A query for 12 month rolling values 0
SUM NOT INCLUDING ALL RECORDS 4
Sum Values from different column 1
Parameter Problem 4

Back
Top