Cumulative in Graph

[Randi A. Dertzo]

Hi,

Can someone tell me how I can do a cumulative graph?

I'm creating a graph that gives the number of new employees and the number how are leaving for a articular department over 12 months. I was asked to give a cumulative total each month within the graph. (not a big total at the end, each month cumulates the previous months but does not count the months after it.)

I've looked everywhere I can think of in the MS Graph & reports utilities but can't seem to find the option to do this. Is there a property or do I have to generate the code and cumulate it manually using VBA and SQL? Any idea how to do that if this is the case?

ANY help would be appreciated.
Thank you for your time,
Randi

 

[Carol]

In your query add a total line and ask for a sum. In your starting and termination date fields, insert a parameter that asks the user for the from and to date. Make sure that your graph date is summing on the month format.

 

[Randi A. Dertzo]

I can't seem to make that work.

I have one Combo box where you can select the job title, then there's a field (will change it to CB as well) that asks the years (1999-2000 for example).

Each year has 13 periods, no moe no less.

When I add a Sum in the query, nothing different happens.

Here's an example of what values I have:
Period 1 = 1 Left, 2 Hired
Period 2 = 3 Left, 1 Hired
Period 3 = 9 Left, 8 Hired
Period 4 = 1 Left, 9 Hired
...

The cumulative graph shoul have the following values:
Period 1 = 1 Left, 2 Hired
Period 2 = 4 Left, 3 Hired
Period 3 = 13 Left, 11 Hired
Period 4 = 14 Left, 20 Hired
...

Where the period (1 to 13) is displayed in the X axis, the Left and Hired are the "sticks or line (the actual result)" in the graph.

 

[Carol]

Try using unbound combo boxes with parameter queries. Your user parameters should be linked not only to your dialog users box, but also to your graph report and your underlying query. If you still have problems maybe you can e-mail me a sample of your query.

 

[Randi A. Dertzo]

Finally, I made it work!

Thanks for your help Carol.