getting a chart to display a selected range of data

[cool hand]

Hi, i have a chart that needs to display results by date order as selected by the user, the chart needs to show the last 16 weeks data collected. I have got the chart to work properly but i can't figure out how to tell it to only display the results within a certain range...(in Excel you could specify a series range, but can't find the equivalent in Access) any help or pointers will be most appreciated

 

[tpeter]

Hi, i have a chart that needs to display results by date order as selected by the user, the chart needs to show the last 16 weeks data collected. I have got the chart to work properly but i can't figure out how to tell it to only display the results within a certain range...(in Excel you could specify a series range, but can't find the equivalent in Access) any help or pointers will be most appreciated

In the properties of your report what is the row source data? Is it pulling information from a query? If it is all you have to do is find the date filed (in design view) of your query and in the criteria section type Between [Enter Start Date] and [Enter End Date].

 

[tpeter]

If your Chart is based on a query all you have to do is go to the row source of the chart and open the query that supplies the information. In the date field (looking at design view) go to the criteria section and type Between [Enter Start Date] and [Enter End Date]. This will give you a message box everytime you open the report so you can change the time intervels.