Hiding Nil Order Quantities

[LJtechnical]

Hi

I have a report which shows the order data from a table but I would like the report not to include the order items that have a Zero order quantity. Is there some code I can use to hide these report records?

Thanks

 

[Norris68]

Use a query for your report. Instead of opening the raw table, create a query to base your report on making sure that your order quantity is greater than zero e.g.

SELECT * FROM TableName WHERE OrderQuantity > 0

To create a query, click on the '...' button to the right of the RecordSource box in the Properties window.

 

[LJtechnical]

Cheers for that! Havin one of those days where the blindingly obvious escapes me! Didnt even need to set up a query, just added the where condition to the data source property.

Thanks again.