Create Graph/Report/PivotChart from Running Sum Queries

maggioant

Registered User.
Local time
Today, 16:22
Joined
Sep 30, 2009
Messages
15
Has anyone had trouble creating a graph of the running sum field?

I am new to Access and trying to create a comparison graph using two queries:

Query 1: [Yr], [Mth], [Count_New_Issues], [Total_New_Issues]
Query 2: [Yr], [Mth], [Count_Closed_Issues], [Total_Closed_Issues]

Where [Total_New_Issues] and [Total_Closed_Issues] are running sums.

I am trying to create a bar graph that will compare the two totals fields. How do I create this?

Issues.jpg
 

Users who are viewing this thread

Back
Top Bottom