Reports with multiple charts

[lisa1965]

I am new to access applications and I have created about 10 reports, each contains a column results, bar chart and pie chart. The column results works great, the filter option is turned on for 2 fields in the report and the results filter correctly, then I created the 2 charts based on the same query but the filter for the chart data only works on one field so the results do not match the column results. I have used the "Link Master Fields" and "Link Child Fields" to get the one field to work but access is not allowing me to enter two fields in this chart property. Any help would be greatly appreciated.
Thanks

 

[lisa1965]

Solution

Thanks for letting me post! I have figured it out and wanted to give the solution in case anyone else has a problem. On the properties of the chart in the Link Master Fields and Link Child Fields I am able to enter in multiple fields separated by semi colons. I was using the logical operator And and getting an error message. Hope this helps someone else in the future.