HOW DO I LEAVE OUT ZERO VALUES FROM REPORTS

[KarenD]

I'm writing a stock control database and having a problem reporting on stock
in hand. I've got all the tables and queries done and the answers are coming
out correct on the report BUT I don't want to print nil value stock on the
report, only lines where we have stock. Is there a way of suppressing zero
values in the report, or query?

 

[fredg]

I'm writing a stock control database and having a problem reporting on stock
in hand. I've got all the tables and queries done and the answers are coming
out correct on the report BUT I don't want to print nil value stock on the
report, only lines where we have stock. Is there a way of suppressing zero
values in the report, or query?

Set the Format proprety of that control on the report to:
#,-#,"";

 

[Evi]

Some of this would depend on your db structure. You would have one table for
StockItems
TblStockItems
StockID (PK)
StockItem
KeepIn (Number of this item you wish to keep in stock)
RetailPrice etc
Locat (item location)
ExStk (Ex Stock Yes/No - tick if this item is no longer being used)

The second table contains stocktake. You may want to use an append query
(filtering out the ExStk) to add all items to this table then base your
report on a query which filters out those with 0 in the IQuant or delete
them as preferred.

TblStockTake
STakeID (PK)
StockTakeDate
StockID (linked from TblStockItems)
IQuant (Quantity of those items at the time of the stocktake.
IValue (Value of the item - ie the Retail Price *at the time of the
stocktake*.

Evi