I am trying to compile a report, based upon a query, that would display only fields with valid data (i.e., the field total is greater than zero or not equal to zero.). This report is based upon a query which selects all possible fields from various tables.

How can I achieve this, either by modifying the query or the report format? I appreciate your help.

If your referring to fields that are blank
In the criteria for the field that are
required to be filled enter:
Is Not Null

If you really mean "Zero" or a negative number then in the criteria put:
> 0

HTH