I work in a school dealing with troubled teens and have created an ACCESS database for recording their behavior. I am frustrated with the graphing limitations of ACCESS and would like to link ACCESS data to EXCEL so that I can use its extensive charting capabilities and to pre-define graph properties for users so they can create charts merely by selecting a "student" and a date range.<br><br>I have solved most of the issues however, I have a problem regarding specifying the data range. The problem is that the number of records retrieved is variable. How do I specify a range of data within excel that is variable and depends on how many records happen to exist within an ACCESS query??? Or, is there a way to create an EXCELL chart directly from an ACCESS Query (again with the number of records varying with each use)?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
automatically linking ACCESS query data to EXCEL for charting???
- Thread starter hoko
- Start date
You need to create a table in the database and allow the query to select the maximum amd minimum values of the range from this table.<br><br>Reserve two cells in your excel sheet one for the maximum and the next for the minimum. <br><br>after these values are inserted, use code in the excel workbook to copy them into the table after which you should execute the query that returns the data to the worksheet.<br><br>Be sure to delete the data from the table after the query is excetuted.<br><br>Hope this helps<br>
- Status