Chart Object

[GregD]

I have a report with a chart as a subreport. The data for the chart is stored in a table where each PersonID has 4 rows. This PersonID is the link field that ties the subreport to the main report. The main report data is drawn from a different table.

Each row in the subreport table has a value that is graphed, along with a date and counter field for each set of 4 values. That is to say, PersonID = 1 has a 4 rows and each row has a field with either a 1,2,3, or 4. Then the next personID has a 1,2,3,4. This counter field is used as the X axis of the graph and corrisponds with the date.

PersonID      Date   Value    Counter
1        01/01/2007    7    1
1        02/23/2008    6    2
1        03/04/2008    12    3
1        12/24/2008    8    4
2        03/01/2004    7    1
2        05/23/2006    6    2
2        07/12/2008    12    3
2        09/24/2008    8    4

Beacuse each set of 4 rows for the PersonID all have the same 1,2,3,4 values I can make a crosstab query for the graph. What I would like to do is use the date as the x axis. Because the 4 dates associated with the each PersonID are different, I can't figure out a way to do this.

Any help is appreciated.

Greg