Pagination graphic report in vba access

[Pietro75]

Good Morning,
It 'the first time they place on your forum.

My problem is the following:
1) I have created a report that contains a chart, you can see it in the image I have attached.




2) The chart displays only 30 records (first column of the histogram = 1 record). In fact the table where fishing data could also have 200 records.

3) my idea (or what I wanted to get) was to create as many graphics as 30 columns at the one to get the display of 200 columns (200 columns = 200 records).

4) Then I would get 6 graphics by 30 columns + a last graph 20 columns that will be the remainder to get to 200.

I am a newbie vba.
I come from vb.net.

If someone was kind enough to direct me towards the solution of the problem.

Thanks in advance!

[rpeare]

I do not understand the question. Perhaps if you provided a sample database it would be easier to help.

[June7]

Your image did not upload.

Possibly the chart RowSource needs to be a CROSSTAB query with filter parameter.

As rpeare suggests, attach db for analysis.