Report to Not Show a Record IF a value is=(0)

[Corey]

Is there a way to set a report to not show/print records that have a
perticular vale that equals ZERO ?
How can i do this?

 

[fredg]

Is there a way to set a report to not show/print records that have a
perticular vale that equals ZERO ?
How can i do this?

The proper way is to filter out those records in the report's record
source query.
..... Where YourTable.SomeField <> 0

 

[Corey]

Thanks for the reply Fred.
Excuse my niavity, but how do i do what you are saying?

I want the record to be still there in the table, but not to be displayed in
the report.

I tried to enter some sort of code into the (Split Belt Table), when to DATA
SHEET View, and Highlighted the Column that has the values that can be ZERO.
Then clicked properties, clicked Data and in the filter box enter
something???

Is that what you meant??
The field name is (Length Remainging in Stock), and if this value is (0)
ZERO then I do not what that entire record to be displayed int he report.

 

[fredg]

Thanks for the reply Fred.
Excuse my niavity, but how do i do what you are saying?

I want the record to be still there in the table, but not to be displayed in
the report.

I tried to enter some sort of code into the (Split Belt Table), when to DATA
SHEET View, and Highlighted the Column that has the values that can be ZERO.
Then clicked properties, clicked Data and in the filter box enter
something???

Is that what you meant??
The field name is (Length Remainging in Stock), and if this value is (0)
ZERO then I do not what that entire record to be displayed int he report.

No! That is not what I mean.

This is for a report isn't it?

Open the REPORT in Design View.
Show the report properties box.
Click on the Data tab.
Click on the Record source line.
Click on the button with the 3 dots on that line.
The Query Builder will open and display the Show Table dialog box.
Select the Split Belt Table and add it to the query.

Drag each field that you need in the report onto the lower panel, one
field per column (you may need all the fields or just some of them).

Then, on the [Length Remaining in Stock] Criteria line (in the lower
panel) write:
<> 0

Save this.
This query then becomes the record source for the report.

Any record with 0 in the [Length Remaining in Stock] field will not
appear in the report.