Summing column that includes #Error values

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?
 
M

Marshall Barton

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

MS Project Import Error Row 1 Column 5 2
Macro warning in word 1
Setting column width in a table with a macro is not working 0
Cumulative formula for word table 0
Strange values when summing in a query 1
Parameter Problem 4
Summing values where one is #Error doesn't work 3
Summing multiple fields 2

Top