Show selective records

[KarenS]

Hi,
I have a report which pulls data from a query. I have a checkbox field in the query and I want to be able to show only those records where the check is "Yes". I did some code to hide the fields on the report, but even though it hides the fields, it still adds to the grand total. (The records have currency totals).

Is there a way to show only fields with the "Yes" selected, and not have the totals add to the grand total?

Many thanks..

 

[MStef]

Make a filter on query (Criteria on Checkbox).

 

[KarenS]

Thanx,

I used a filter in the form properties and it worked!