Chart?

[chooriang]

Hi,
I made a table structured as below

1.No Number
2.Date Date and Time
3.Model Text
4.Accept Qty Number
5.Reject Qty Number
6.AA Number
7.BB Number

Reject Quantity is sum of AA and BB.
The Result that I want to get:
I want to get a chart where data comes from
a sorted record.( if possible the chart change automatically
base to the sorted record )For example: I want to get the reject
detail from 'this model' in 'a periode of date' or I want to get
total reject quantity in a month for all model.

Please help,how to do that.

Thank's before,

Cho

 

[Ed Robichaud]

Some generic comments first.
"Date" is a reserved word, so rename your field to something else. Also
rename your fields to remove spaces between characters, otherwise you'll
need to always enclose the names in [ ]. Don't store calculations; rather
calculate them on the fly in forms & reports as necessary.

Now to your question: Look at the examples of Pivot Charts; theses are
dynamic charts/graphs of the underlying data that can be filtered and have
there axis replotted on screen.
-Ed