Posted on 2000-03-17
I need to set up a chart that tracks the progress of test being performed in an Access database. These charts have to contain a running sum for test data entered into the database. For ex. 02/5/00 there were 10 test completed and 02/6/00 10 cases were completed so on 02/7/00 the sum should be 20 before the next calculation is processed. I made all of the queries required and made reports based on the queries(to make the running sums because of the running sum property in Access reports)...After that I made a macro for each report and it transferred the data from the reports into my excel spreadsheets where I created the charts. After doing this I saved each chart as a different name and saved them to the server so all the users may access them through the database. I set up a cmd button in the database for each chart that links the database to the specified chart in excel. Everyone around here is happy, but my problem is that the charts are static and the only way for me to keep them up to date is to check the reports (in access) which are linked to the dynamic queries each morning and cross reference the data. There's gotta be a way to create a dynamic link from the database to the charts in excel...So when the users click on one of the chart buttons in access it immediately takes them to excel and the graph that is displayed contains the most updated information which is reflected in the reports.