Can You Filter a Chart the Same way as a Report??? (1 Viewer)

[Sly600rr]

Hello everyone,

I have a form using text boxes to build a filter for a report, I have 2 charts inside the report. I can run the report through my filter, but the charts use the unfiltered data from my query!!! how can I run the same filter through my charts? or how can I make the charts use the data from the report instead of my query which has all the records.?!?

Please Somebody Help me!!!


Thank you

 

[jal]

Hello everyone,

I have a form using text boxes to build a filter for a report, I have 2 charts inside the report. I can run the report through my filter, but the charts use the unfiltered data from my query!!! how can I run the same filter through my charts? or how can I make the charts use the data from the report instead of my query which has all the records.?!?

Please Somebody Help me!!!


Thank you

I assume you have a "Run Report" button on the form. In the handler for that button, use a DoCmd.RunSql to output the results of the filter-query into a table called tblForCharting. Then base the chart on that table.