Outsmart Access to get pie charts from parameterized queries

摘要

Adding a chart in a report is usually a fairly straightforward process, except when a parameter query is the data source for the report. Unfortunately, you may have to provide your query criteria multiple times and, in some cases, Access refuses to display the chart at all. Luckily, you don't need a chart control to graphically display data in a pie chart.