Report ONLY If ...

D

Dane

I have an Inventory Database which has a field called STOCK. This field is
used to indicate the type of stock it is (S for Stock, TS for Temporary
Stock, etc.) If a product is NOT stocked then this field is left blank (no
data).

I would like to create a report that only shows the products that have data
in the STOCK field.

I am not having much success getting this to work.
 
A

Al Camp

Dane,
In the query behind the report, use this criteria against the Status field
Is Not Null
 
A

Allen Browne

Create a query.

Drag the Stock field into the grid.

In the Criteria row under this field, enter:
Is Not Null

Use this query as the RecordSource for your report.
 
Top