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.
