Access-x.zip

<div>
tonikgroup,<br />
<br />
I took a slightly differnt approach.<br />
<br />
I generated and inserted the Index Field values directly in the Return Table itself, by using the code on the form named: frmGenerataData.<br />
<br />
Then Plotted the chart directly from the table.<br />
<br />
JeffCoachman<br />
<a href="https://filedb.experts-exchange.com/incoming/2008/10_w43/71273/Access-BasciReportByOneFieldDate.mdb" target="_blank" class="file-inline" title="sample (608 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Access-BasciReportByOneFieldDate.mdb</a>
</div>


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 [https://filedb.experts-exchange.com/incoming/2008/10_w43/71273/Access-BasciReportByOneFieldDate.mdb]

Access-BasciReportByOneFieldDate.mdb

<div>
Thank you hnasr!<br />
<br />
Jeff, It seems that you've uploaded the wrong file?<br />
<br />
I never regret subscribing to experts-exchange!<br />
<br />
Regards<br />
tonikgroup<br />

</div>


Thank you hnasr!

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

I never regret subscribing to experts-exchange!

Regards
tonikgroup


<div>
tonikgroup,<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; &quot;Jeff, It seems that you've uploaded the wrong file?&quot;<br />
Yes but wasn't the file informative anyway?<br />
;-)<br />
<br />
LOL<br />
<br />
Here is the real file (I hope!)<br />
<br />
Jeff<br />
<a href="https://filedb.experts-exchange.com/incoming/2008/10_w43/71291/Access-EEQ23836472GraphChartCumm.mdb" target="_blank" class="file-inline" title="sample (624 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Access-EEQ23836472GraphChartCumm.mdb</a>
</div>


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 [https://filedb.experts-exchange.com/incoming/2008/10_w43/71291/Access-EEQ23836472GraphChartCumm.mdb]

Access-EEQ23836472GraphChartCumm.mdb

<div>
Thank you Jeff!<br />
<br />
Everything coming from your team is informative.
</div>


Thank you Jeff!

Everything coming from your team is informative.

<div>
What was the deciding factor?
</div>


<div>
<div class="content wysiwyg-content">
Hi <br />
<br />
What I have:<br />
- a set of monthly returns in a MS Access. I've attached the Access table.<br />
<br />
What I would like to do:<br />
- In MS Access, <br />
- create a cumulative graph showing how say a 100 USD would have grown over time by each of the monthly returns. &nbsp;I've attached how I would do this in excel.<br />
<br />
How would one do this completely in Access?<br />
<br />
Thanks <br />
Jann<br />
<a href="https://filedb.experts-exchange.com/incoming/2008/10_w43/70611/Desktop.zip" target="_blank" class="file-inline" title="Access table and excel example (52 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Desktop.zip</a>
</div>
</div>


Desktop.zip

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

Cumulative Line graphs in MS Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.