If field = 0 display nothing - how?

R

Richard Horne

Hi, I am creating a delivery note report which displays the items in a
particular shipment that are included in a parcel. I have a field for each
item called Quantity_Delivered how can i make my form so that if the
Quantity_Delivered = 0 then no information is displayed for that item? But if
the Quantity_Delivered >0 then the whole item and its fields are displayed.
 
J

John Ortt

in the query window write the following:

New_Quantity_Delivered :
iif([TableName].[Quantity_Delivered ]=0,Null,[TableName].[Quantity_Delivered
])

Sorry.....just reread and I think I misunderstood the first time.

Is it not just as simple as putting a criteria of ">0" in the query for the
report?

That should filter out all parts with a 0 entry.

Hope that helps,

John
 
Top