Access Query Output to report Summation problems

  • Thread starter Thread starter Enrique Rojas
  • Start date Start date
E

Enrique Rojas

Hello,

I have a query that I output into a report. When I use the sum
function in the report control source property field I get a mismatch
error when I run the report.

example

CURRENT DOLLARS
2.00
-
3.00
-
-

=Sum(current_1)


the "-" signifies nothing, the output is blank on the report and in
the database there is no data stored there.

I read that the sum function ignores null. Is there a way where I can
sum the above example?

Also, I cannot populate the cells with 0's because 0 is an actual
value.

Thanks in advance
 
Is it possible that current_1 is NOT numerical (but text). So, summing text
would produces the 'mismatch', because a number is expected, not a text.

=SUM(val(current_1 & ""))

is working?


Vanderghast, Access MVP
 
Back
Top