I hope someone can help with this... I have a form that allows users to select dates and categories for a report that is then opened once the selections are made. The report data is based on the selections made on the form. Allmy calculations etc work fine in the report and use the appropriate data except for the charts. The charts all contain the same data, i.e. the are ignoring selection criteria, one chart should be for males and the next for females for a particular time period, but instead both charts contain data for males and females for the entire database not the specified dates.
I have looked through previous posts suggesting use of a subform for charts but I am unsure how that would work because of the need for users to select data filters. Does anyone have any suggestions?
I have looked through previous posts suggesting use of a subform for charts but I am unsure how that would work because of the need for users to select data filters. Does anyone have any suggestions?
