records in subform visible

[Abrm]

I have a report with a subform.
The subform is bound to qeury.
number,visible,amount

In the subform I only want to see the records with the
option visible. In the subform footer I want a total of
the amounts of all records(including the records that are
not visible).
Now I set the qeury to critreia of visible, but then I
miss some of the amounts.
I tried to run code that makes the fields not visible, but
then all fields are not visible.
What's the best way to do this?

thanks

Abrm

 

[Allen Browne]

If you want to hide just one box and leave space there, use conditional
formatting to set the font color to white.

To suppress the printing of the entire record, set the PrintSection property
of the Detail section in its Print event.

An alternative approach would be to filter out the non-visible records from
the subform's recordsource, and use a DSum() expression to calculate the
total from the table. This would probably be the fastest solution.