Steve Erbach
erbachs at gmail.com
Thu Feb 10 20:00:35 CST 2005
Dear Group, I found my own answer. I placed a text box into the Group footer and named it txtSourceID and bound it to the SourceID field. I then removed the graph from the Group footer, created a subreport and created a graph in its report footer. The subreport Record Source and the graph's Record Source are identical. They both contain WHERE clauses like this: WHERE SourceID = [Reports]![rptWaste]![txtSourceID] So now the proper graph prints in the Group footer for each SourceID. Steve Erbach Neenah, WI On Thu, 10 Feb 2005 19:09:02 -0600, Steve Erbach <erbachs at gmail.com> wrote: > Dear Group, > > Now I've got an issue with graphing in a report in the project I'm > converting to Access from Paradox. > > The Paradox application allowed a graph to print in a group header or > footer that sumamrized data appropriate to that group. Then an overall > graph would print in the report footer. Here's what the raw data looks > like: