How to filter Graph data analysis by date range (Start Date to End Date)

[fluffyvampirekitten]

How can I filter graph data ..
I want
1) Button Update Range (of the graph) e.g Start date: Jan 2014 to End Date: Dec 2014
2.) Then it will automatiacally the analysis thru bar chart.


Thanks in advance

[ranman256]

Make a report form, frmRpts
on it are 2 text boxes named, txtStartDate, txtEndDate
in the query the chart uses, the criteria would have
select * from table where [date] between forms!frmRps!txtStartDate and forms!frmRps!txtEndDate
Just to be safe, in the parameters property of the query put : forms!frmRps!txtStartDate as date , (same w end date)

a list box of reports you want to print, select from the list (your chart) , lstReports

the button on the form to open the report, docmd.openreport lstReports

[fluffyvampirekitten]

Make a report form, frmRpts
on it are 2 text boxes named, txtStartDate, txtEndDate
in the query the chart uses, the criteria would have
select * from table where [date] between forms!frmRps!txtStartDate and forms!frmRps!txtEndDate
Just to be safe, in the parameters property of the query put : forms!frmRps!txtStartDate as date , (same w end date)

a list box of reports you want to print, select from the list (your chart) , lstReports

the button on the form to open the report, docmd.openreport lstReports

Thanks! However , I have a form with a chart on it. Above it is a button to go to another page to allow user to click on the start and end date.
I tried to apply the same concept of what you have told me .
However a dialog box keep appearing

PARAMETERS [Forms]![Summary_Range]![cboStartRange] DateTime, [Forms]![Summary_Range]![cboEndRange] DateTime;
TRANSFORM Sum(Summary.No_of_Recordset) AS SumOfNo_of_Recordset
SELECT Summary.Record_Period
FROM Summary
WHERE (((Summary.Record_Period) Between [Forms]![Summary_Range]![cboStartRange] And [Forms]![Summary_Range]![cboEndRange]))
GROUP BY Summary.Record_Period
PIVOT Summary.Category;

For Parameters , I couldn't find the data type "Date"

[fluffyvampirekitten]

Make a report form, frmRpts
on it are 2 text boxes named, txtStartDate, txtEndDate
in the query the chart uses, the criteria would have
select * from table where [date] between forms!frmRps!txtStartDate and forms!frmRps!txtEndDate
Just to be safe, in the parameters property of the query put : forms!frmRps!txtStartDate as date , (same w end date)

a list box of reports you want to print, select from the list (your chart) , lstReports

the button on the form to open the report, docmd.openreport lstReports

hahaha! I fixed it . Thank you so much for the help!!!! Been trying to solve this prob for a few days already ! Appreciated your help and guidance

[cap.zadi]

Hi

Thanks for the post and discussion.

I have been looking for the same kind of material.

Can you illustrate lit bit more for better understanding of this?