Hide Zero Value Field/Column

[jasonx]

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.

 

[OSCSLeo]

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

 

[ootkhopdi]

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

this shows error

 

[Mihail]

Use Excel and show us in the first 3-4 columns how the data is now and in other 3-4 columns how the data should be in your opinion. Then upload this file.
Note: Use .xls file format and zip it before uploading.

 

[Pat Hartman]

Change the query used as the RecordSource for the report to include criteria that selects only the data you want to display.

Select ...
From ...
Where SomeField >= 0;

 

[ootkhopdi]

Use Excel and show us in the first 3-4 columns how the data is now and in other 3-4 columns how the data should be in your opinion. Then upload this file.
Note: Use .xls file format and zip it before uploading.

Thanks sir
as for your requirement
i m uploading example in xls file
pls help me

 

[Mihail]

.... that would display only fields with valid data (i.e., the field total is greater than zero or not equal to zero.)

As I suspect, not the field TOTAL is the criteria but the field where all values are 0 (zero) (at least this is what I understand from your Excel file).
In this thread is a very simple database that can be a start point for you.
Of course, you should implement the logic to know if a field has only zero or not.
A DCount function with a <>0 criteria (applied for each field) should work.