mark curtis
Registered User.
- Local time
- Today, 11:06
- Joined
- Oct 9, 2000
- Messages
- 457
Dear All,
Another little problem for which I once again call on the help of more advanced access folk than me.
I have a report based on a query which also contains many subforms such as highlights, products, risks, dependancies.
When I run the report all of the subforms may contain data OR only some may contain data OR none may contain data. What I need to do is IF only some of the subforms contain data then I need to hide the subforms which have no data(it may have no data but the labels the subform label still appears). Also if a the subform contain no data then I want to return a label saying NO Data This Month.
Ian suggested if I wanted to check and see if there were any records to view before viewing I suppose you could do something like creating a recordset clone of the subreports data and conditionally viewing/hiding dependent on whether the recordcount is >0
But I do not know how to do this and would appreciate an example.
If there are any other methods I would also appreciate any help.
Thanks again, Happy New Year.
Mark
Another little problem for which I once again call on the help of more advanced access folk than me.
I have a report based on a query which also contains many subforms such as highlights, products, risks, dependancies.
When I run the report all of the subforms may contain data OR only some may contain data OR none may contain data. What I need to do is IF only some of the subforms contain data then I need to hide the subforms which have no data(it may have no data but the labels the subform label still appears). Also if a the subform contain no data then I want to return a label saying NO Data This Month.
Ian suggested if I wanted to check and see if there were any records to view before viewing I suppose you could do something like creating a recordset clone of the subreports data and conditionally viewing/hiding dependent on whether the recordcount is >0
But I do not know how to do this and would appreciate an example.
If there are any other methods I would also appreciate any help.
Thanks again, Happy New Year.
Mark