Displaying 0 in a report with a null value returne (Access97)

[gbanks]

I have a report now that I run and if the result of report is 0 or null it just displays the field as blank. Is there a way I can tell the report that if the value of this field is null then to place a zero in this field. Maybe something like: If Me.[Total] Is Null Then = 0? Any help is appreciated. Thanks

[MarkLiquorman]

This may be a combination of 2 things. First of all, use the NZ() function to make the value of the field zero if it is null. If it is a field from the query, you can use: NZ(yourfieldname, 0) for example.

Then, check the formatting for the field. Make sure the format has a 0 (zero) as the rightmost character.

[ThomasW]

Use the Nz function to return zero when the value is Null.

Nz([Your FieldName],0)

You can look up the Nz function in Access Help for more detail.