turtsmurt
New Member
- Joined
- Mar 4, 2010
- Messages
- 45
Hello all,
I'm sure this has been asked before. I'm not new to Access, but I'm not great with VB code.
I have a subreport that is listed by a group header in the main report. The subreport gives total counts based on a query with various criteria.
Since the main report is based on a seperate query I have been successful at getting the subreport to remain with its group, however, I need the subreport to reflect zeros when there are no results under that grouping. Or even to reflect a message that there are no results for that group.
I've tried adding a textbox overlapping the subreport with an IIf expression, however, all I get with that is an #error result.
The funny thing is that in Report View, those subreports actually show up as zeros, but in the print copy they are just blank.
Any ideas or helpful instructions would be greatly appreciated.
Christine
I'm sure this has been asked before. I'm not new to Access, but I'm not great with VB code.
I have a subreport that is listed by a group header in the main report. The subreport gives total counts based on a query with various criteria.
Since the main report is based on a seperate query I have been successful at getting the subreport to remain with its group, however, I need the subreport to reflect zeros when there are no results under that grouping. Or even to reflect a message that there are no results for that group.
I've tried adding a textbox overlapping the subreport with an IIf expression, however, all I get with that is an #error result.
The funny thing is that in Report View, those subreports actually show up as zeros, but in the print copy they are just blank.
Any ideas or helpful instructions would be greatly appreciated.
Christine
