suppress records containing predetermined value

[keithsimpson3973]

Hi, working in Access 2003. In my report, I have a field that contains a qty. If the qty is equal to zero , then I would like access not to display that record on the report. I thought you could do something like "On Print" or something like that? Is it possible to even do it?

Thank you

[pks00]

Could u not change the query that the report is based on and add a filter in that query?

[keithsimpson3973]

I could create one. Right now it pulls data directly from the table. It would be a lot better if I could do it in the report as the table has a lot of fields in it that the report is displaying.

Thanks for the tip, though.