Hello Richard,
If you highlight the total line and right mouse button on the Row number, what is the setting of the Zero suppress option on the pop-up menu?
Also, if you actually print (or print preview) the statement, is the zero suppression working (sometimes the design view shows rows that will be suppressed when the statement is printed).
_________________________
Andrew Bates