ACCESS FEED: [MS_AccessPros] Help wit report format

Kamis, 21 November 2013

[MS_AccessPros] Help wit report format

Hello,I have a report that I'm modifying. The original report was created by a person who is no longer with the company. Basic format has several queries which each feed a separate report. Then there is a final report that has all the other reports included. The final report is what is printed each week.

When there is a report that is not to be included in the final report (ie - no data for that week), the report has to be manually deleted from the final report form. If the sub report is set to "not visible", then there is an unwanted gap in the final printout.

What I'm wondering is - is it possible to have a single report that allows sub headers for the matching query where when there is no information in the query the sub header does not print - OR when the sub header is set to "not visible" there is not a gap in the report?

Explained another way:

Currently:

Query 1
Query 2
Query 3
Query 4
Report 1
Report 2
Report 3
Report 4
Final report w/
Report 1
      Report 2
      Report 3
      Report 4

Now if Query 3 returns nothing, then the final report is
Final report w/
Report 1
      Report 2
      - gap -
      Report 4

Best solution would be to have:
Final report w/
     Query 1
     Query 2
     Query 3
     Query 4

Or
Final report w/ (query 3 with no results)
     Query 1
     Query 2
     Query 4

BTW, I'm knowledgeable enough to be dangerous but can be trained :)

Thanks,
B