I'm having a bit of a problem with my Access chart. For some reason, when I run the report it will bring up the report with the chart correctly... but then it wants to add a bunch of extra pages after the first. I'm not sure why it's doing this.
Originally posted by Sucoyant
If you select 1 employee from the list, 21 pages total.
If you select 2 employees from the list, 35 pages total.
They aren't really blank... they have the report heading, and the chart outline, but no data within the chart.
Try adjusting your page layout of the report. See if that doesn't reduce the # of pages. (BTW, I have a report that if the top margin is off by .15 depending on the printer set as default, I have an extra 2 pages to contend with ...)
I Change the record source of the report to a totals query that returns only one record per employee:
SELECT [Lease Assignment].[Employee] FROM [Lease Assignment] WHERE ((([Lease Assignment].[Date]) Between [Forms]![Menu]![txtLA_PRfrom] And [Forms]![Menu]![txtLA_PRto])) GROUP BY [Lease Assignment].[Employee];
Now I just have to figure out why it wont display data for more than one person.
If you download the databases, make sure to place the above SQL into the recordsource of the Graph report.