Pivot Chart

[rbrown75]

Hello,

I would like to create a report with a chart that only returns records based on my selections. I would like to filter by CustomerID, DateFrom, and DateTo. I would like the date fields to be a fill in text box. I have created a query that is filtered through a form by CustomerID with a combo box. This form also has a command button that opens the report with the pivot chart. The query filters properly based on the selection in the combo box on the form. The problem is when I open the report the chart is pulling all customers versus the customer selected on the form.

I'm also working in Access 2013. I'm what you would consider a newbie to access. Any assistance in helping me determine why the chart is not filtering properly would be great.

thanks,

Ruth

 

[jdraw]

Not knowing any of the details of your data or form design, it would seem that the filtering
that works on the form is not being used or sent to the report.

What exactly is the record source of the Report?

I have not used Pivot chart(s) for a very long time.

You may get some insight from this M$oft video