Adding multiple field with blank section

[Philip N.]

Hello,

I am creating a table in access 2010 for my consumable and bench stock report. I made a 12 fields which I name it the month of the year and another 1 field to add the total disburse materials in one whole year. I did this formula to add the 12 fields [Jan]+[Feb]+[Mar]+[Apr]+[May]+[Jun]+[Jul]+[Aug]+[Sept]+[Oct]+[Nov]+[Dec].

But the problem is its just adding the complete consecutive months that I disburse and the row with blank section the total disburse doesn't show on the total disburse for the whole year. I try to use the code =Nz([Total Disburse],0) but it shows on the screen i cannot be used in calculated column.

Please help me out to solve my problem.

Thank you,
Philippe

 

[CJ_London]

Smacks of poor table desing but if you need to go this way then you need to use nz within your formula e.g.

nz([Jan])+nz([Feb])+etc

 

[Philip N.]

Hello CJ,

I tried the formula that you give, and there is a pop out warning that the expression Nz cannot be used in the calculated column.

 

[CJ_London]

better provide the code you are using

 

[alcapps]

try adding Nz(Jan,0) + Nz(Feb,0)....