How to hide certain records

[bugman]

To who ever can help? I have a report that has 4 post cards “accounts” on each page. The control source is a table. The post cards have the customer’s info and their service charge amounts. What I need is a way for only the post cards “accounts” with a $0.00 service charge to not show up when I run the report. If I can do this in code, please show me. And, if I can do this in a query, please show me. Any help is greatly appreciated.

 

[Pat Hartman]

Select ...
From ...
Where ServiceCharge <> 0;

 

[bugman]

Thanks Pat, I had a brain freeze.