I have a report that includes main headings, and may include 10 sub-headings that will be listed underneath each one.
I want to be able to print this report and include only those sub-headings that are populated, leaving out the blank spaces for those sub-headings that are not populated.
I know that in designing my report, I have to accomodate the possibility that all 10 sub-headings may need to appear under a main heading. Therefore, I have the fields for all 10 sub-headings on the report... but is there a way to tell Access that, for example, if sub-headings 7-10 are null, then don't leave spaces for them? If I can do this, then in this example my next main heading would start just underneath sub-heading 6.
Thanks in advance for your help.
I want to be able to print this report and include only those sub-headings that are populated, leaving out the blank spaces for those sub-headings that are not populated.
I know that in designing my report, I have to accomodate the possibility that all 10 sub-headings may need to appear under a main heading. Therefore, I have the fields for all 10 sub-headings on the report... but is there a way to tell Access that, for example, if sub-headings 7-10 are null, then don't leave spaces for them? If I can do this, then in this example my next main heading would start just underneath sub-heading 6.
Thanks in advance for your help.