Suppress zero lines in Report

[Fyeung]

Hi there

Is there any way that I can suppress all lines/records with zero amounts in Reports?

I have a report which shows the invoice numbers in the Detail section of my Access Report. However, there are several lines of invoices with zero amount. How can I get rid of them?

Please advise, thanks.



Fred

[June7]

Maybe with filter criteria in the report RecordSource or the report Filter property or when the report is opened.

DoCmd.OpenReport "report name", , , "[Amount]<>0"

[Fyeung]

Thanks June7