IIF euestion once more

[Guest]

On my report I have the summary field which is showing #Error when there is
no data matching query criteria (date range). To show blank instead of #Error
I am trying:

=IIf(IsError(Sum([Actual Cost])),Null,Sum([Actual Cost]))

but error does not want to go away. How to modify this IIf statement to fix
it ?

Tony

 

[Guest]

I have it fixed:

=IIf([HasData],Sum([Actual Cost]),"")

Tony

 

[Duane Hookom]

I try to avoid an IIf() function that might return a numeric value or might
return a string. I prefer to be consistent with the datatype of the result
of the calculation. Consider using:
=IIf([HasData],Sum([Actual Cost]),Null)
or
=IIf([HasData],Sum([Actual Cost]),0)



--
Duane Hookom
MS Access MVP
--

I have it fixed:

=IIf([HasData],Sum([Actual Cost]),"")

Tony

On my report I have the summary field which is showing #Error when there
is
no data matching query criteria (date range). To show blank instead of
#Error
I am trying:

=IIf(IsError(Sum([Actual Cost])),Null,Sum([Actual Cost]))

but error does not want to go away. How to modify this IIf statement to
fix
it ?

Tony

 

[Guest]

Hi Duane,

Thank you for your suggestion. I have replaced 0 with Null.

Tony

I try to avoid an IIf() function that might return a numeric value or might
return a string. I prefer to be consistent with the datatype of the result
of the calculation. Consider using:
=IIf([HasData],Sum([Actual Cost]),Null)
or
=IIf([HasData],Sum([Actual Cost]),0)



--
Duane Hookom
MS Access MVP
--

I have it fixed:

=IIf([HasData],Sum([Actual Cost]),"")

Tony

On my report I have the summary field which is showing #Error when there
is
no data matching query criteria (date range). To show blank instead of
#Error
I am trying:

=IIf(IsError(Sum([Actual Cost])),Null,Sum([Actual Cost]))

but error does not want to go away. How to modify this IIf statement to
fix
it ?

Tony