Many Duplicate Pages

[Matt]

I have a report that runs off a query. The report displays the data in a
graph on one page. But there are hundreds of the same page over and over
again, so if I try and publish the graph into word, it tries to send all the
pages.

Where do I look to try and resolve this issue. I have this same issue with
four other graphs.

Thanks in advance.

 

[John Vinson]

I have a report that runs off a query. The report displays the data in a
graph on one page. But there are hundreds of the same page over and over
again, so if I try and publish the graph into word, it tries to send all the
pages.

Where do I look to try and resolve this issue. I have this same issue with
four other graphs.

Thanks in advance.

Take a look at the Query in datasheet view. Does it show multiple
repeats? If so you may have an incorrect join. Perhaps you could open
the query in SQL view and post it here, with a short example of the
data that you expect and that you see.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps