Solved

Cumulative Line graphs in MS Access

Posted on 2008-10-22
6
545 Views
Last Modified: 2013-11-28
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
Comment
Question by:tonikgroup
  • 3
  • 2
6 Comments
 
LVL 30

Accepted Solution

by:
hnasr earned 500 total points
ID: 22793420
Try this:
One approach, a function to accumulate the index is required, and written inside a module!
Access-x.zip
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22793781
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
 

Author Comment

by:tonikgroup
ID: 22794105
Thank you hnasr!

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

I never regret subscribing to experts-exchange!

Regards
tonikgroup
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22794377
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
 

Author Comment

by:tonikgroup
ID: 22795077
Thank you Jeff!

Everything coming from your team is informative.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22798577
What was the deciding factor?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now