Suppress all details

[blueboron]

I have a Client database with the usual info etc with a checkbox set to true if they are an active client.
I print a client list from time to time but only want a list of active clients.
How do I code this - I know how to 'not show a single field' but as there are 10 fields per client on the report, It will take pages of code.
Can anyone help me please?

BB

 

[pbaldy]

So your query should include:

WHERE Active = True

so you only see active clients.

 

[blueboron]

That works fine.

Thank you very much for your help.

BB