Report ONLY If ...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Dane,
In the query behind the report, use this criteria against the Status field
Is Not Null
 
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.
 
Back
Top