Creating a chart by month

[Lance Kates]

I've a database to track returning shipment. I've a chart that shows the
reasons for returns over the entire history, but I've been asked to also make
a report and a chart for that report that will only show a certain month.
That way if they want to see all returns from January, or March, or December,
they can search for it and see the report and the chart showing why things in
that month were returned.

Any ideas? I know a BIT about Access, but I'm running short on this one.

 

[Duane Hookom]

Your chart has a Row Source which is basically a query. You can set the
criteria in this query using references to controls on forms.

If you can't figure out how to filter a query then come back with:
- Your chart's Row Source SQL
- the name of your form and control you want to use to filter the chart data

 

[Lance Kates]

Well, I found a way to get the report and the graph, using a query that
prompts me for the month I want to search for. However, when you run the
report, it asks for the information 3 times (once for the query that searches
for the month to get ALL the data for the report, once for the query that
gets the information about why things were returned, and once for the
creation of the chart. I'd like a way to only have to put this information
in once, but I don't think that is going to happen. If I haven't confused
you, and you have an idea, let me know
Thanks

 

[Duane Hookom]

The second sentence in my earlier reply suggested "set the criteria in this
query using references to controls on forms". If you need some assistance
with this check out http://www.fontstuff.com/access/acctut08.htm.