cannot convert null/blank to numeric 0

[GinaO]

HI,

If anyone could help me on this i'll be indebted !!


My report is based on a crosstab query which is based on a table.
So column 3 in the original table is now spilt into columns #3 and #4 in the crosstab query.

Some of the values in fields #3 and #4 are blank.
I have to have a 5th column to hold #3 minus #4 but due to the nulls in #3 and #4 values in #5 are incorrect.
I tried NZ and isnull and neither work.


Thanks,
Gina.

 

[Antanas_07]

Hi,
I am having the same problem in very simple situation.
Running query Based on table Customer Complains.
The aim is to create monthly report where I can count complaints every month. Report based on the Query. So I Count the complaints with Month([ComplaintRegisterDate]) and Criteria =1 for January. If I have no complains in January I would like to have 0 in Complaints Column. Nz(ComplaintNumber, 0) does not work.
Thanks in Advance. All help would be highly appreciated.