Converting Null values to zero

[jk12]

Hi all, need some help. In my query I have 4 fields, a weekly labour cost, weekly material cost, weekly plant cost and a weekly summary. The problem I have is that my weekly summary shows a null value on some weeks as not all the weekly costs have a value assigned to them.

I have been told there is a way in the query to convert Null values to zero so that the weekly summary field doesn't show a blank cell.

Could someone please explain to me how this is done? Thanks

 

[MStef]

Try with NZ function.

 

[jk12]

How do you use a Nz function?

 

[MStef]

Look at "DemoNZA2000.mdb". Open Query1.

 

[MStef]

I solved it with "IIf" not NZ, newer mind, it works.

 

[MStef]

Here it is a new one with NZ. Open Query2.

 

[jk12]

Thanks. They work fine