Subform blank when a field is null

[Gkirkup]

I have a form with a subform. The subform is used to report a sales total, for today and for the month. When there are no sales today (a null result in one of the fields) the entire subform goes blank.
How can I make it report a zero in the field instead of blanking the entire subform?

Robert

 

[CJ_London]

use the nz function around the field giving you a problem or redesign your query to exclude nulls