|Thanks - Its not a matter of viewing the charts in one place or another, I physically need to produce a Word document containing fields from data in the database. I also need to be able to manipulate the data in Excel.|
For example, if you had a database filled with all of the houses that sold in your neighborhood - some with carports, some without, some with basements, some without, some with 2,800 SF, some with 2,500 SF.... If you were to compare your house, at 2,500 SF, with a carport and with a basement, you'd want to filter for sales that fit those criteria, then bring them into Excel to say "Ok, these five houses sold... but this one sold a year ago, these two sold six months ago, and these two sold a week ago. I need to correlate the otherwise-similar data based on date of sale, because prices go up and down over time."
The end product is a word document with 1) the raw data, as filtered down to applicable house sales; 2) price-adjusted data in a pre-formatted Excel spreadsheet; 3) the appropriate value, following adjustment to the price for date of sale. Again, the end product [the work product...] is a word document, not the ability to see raw data.