Filling Null Characters with zero character

[Kyriakos]

Hey ppl. I run a query based on a table and 2 other queries, and based on these I get Fcode field from the table and two number fields from the queries (one from each query). If the number is null in either of the fields (it can be null because the number comes from a count statement) I cannot add the 2 fields together, because I always get null unless I have a number on both of them.

Anyway because I think I've confused you enough the title describes best my needs. How to put zero character within a query to replace Null?

Can this be done?

Thanx in advance
Kyriakos

 

[Rich]

Use the Nz function

 

[Kyriakos]

Thanx...First time I 've heard of this function. Used it already...