Build Expression In Query - #Error

  • Thread starter Thread starter tianseng
  • Start date Start date
T

tianseng

Gurus...

I have built a query to calculate a field called Net Value.
In this Net Value field, I want to fit in this formula in th
Expression Builder.

Net Value: sum(iif([Equity]![Net_Value]="",0,[Equity]![Net_Value]))
The formula that I want is
If the Sum of Net_Value from Equity sheet from Microsoft Excel i
blank,
return "0", else
Sum of Net_Value from Equity sheet from Microsoft Excel

However, the field returned #Error when I ran the query. Sometimes, th
system returns Data Type Mismatch error

I need to get this query up and running for the reports soon. Th
management
is banging on the door now..the ironic thing is I am not a bloody I.T
at all !!!

Please help!! I am stucked!
A slice of the Db has been attached for your perusal

Thanks in advance.
 
Are you sure the Net_Value field has a value of "". I would think you could
use:
Net Value: Sum(Nz(Equity!Net_Value,0))
 
Back
Top