Default value

[dawson321]

hi,

i have a calculated feild on a report to add up material totals, but there are not always materials to add up.

I am wondering if it is possable to give this feild a default value of 0, as i am unable to figure out how to do it myself.

is it possable? if yes how can it be done?

 

[Khalid_Afridi]

Yes!
It is possible to cotrol the null value with the NZ function in Ms-Access
Try this:

 

[Fasopus]

When you say there is nothing to add up im assuming what your adding up is null values? If this is the case you could just wrap your calculation in an Nz() function and it would return zero if the sum was null.

 

[dawson321]

How would I put the NZ() in as this is the calculation I have at the moment.

Nz(=Sum([Material Charges]))

 

[DCrake]

Change

Nz(=Sum([Material Charges]))

to
=Sum(Nz([Material Charges],0))

 

[dawson321]

Thanks its sorted now