Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 606
  • Last Modified:

Cumulative Line graphs in MS Access

Hi

What I have:
- a set of monthly returns in a MS Access. I've attached the Access table.

What I would like to do:
- In MS Access,
- create a cumulative graph showing how say a 100 USD would have grown over time by each of the monthly returns.  I've attached how I would do this in excel.

How would one do this completely in Access?

Thanks
Jann
Desktop.zip
0
tonikgroup
Asked:
tonikgroup
  • 3
  • 2
1 Solution
 
hnasrCommented:
Try this:
One approach, a function to accumulate the index is required, and written inside a module!
Access-x.zip
0
 
Jeffrey CoachmanMIS LiasonCommented:
tonikgroup,

I took a slightly differnt approach.

I generated and inserted the Index Field values directly in the Return Table itself, by using the code on the form named: frmGenerataData.

Then Plotted the chart directly from the table.

JeffCoachman
Access-BasciReportByOneFieldDate.mdb
0
 
tonikgroupAuthor Commented:
Thank you hnasr!

Jeff, It seems that you've uploaded the wrong file?

I never regret subscribing to experts-exchange!

Regards
tonikgroup
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Jeffrey CoachmanMIS LiasonCommented:
tonikgroup,
   
    "Jeff, It seems that you've uploaded the wrong file?"
Yes but wasn't the file informative anyway?
;-)

LOL

Here is the real file (I hope!)

Jeff
Access-EEQ23836472GraphChartCumm.mdb
0
 
tonikgroupAuthor Commented:
Thank you Jeff!

Everything coming from your team is informative.
0
 
Jeffrey CoachmanMIS LiasonCommented:
What was the deciding factor?
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now