Hey all



I have a recordset that in a nutshell contains two columns.

Date (mm/dd/yyy) and value (x) (Date spans only 2 years)

I want to use a query to break the table up so that there are columns for each year, and rows for each date (mm/dd) and within are the years

I then want to use this data in a line graph.

the end result being that I have every day of the year in the X-axis and the value in the y and a line for each of the three years.

Thanks in avdvance,

Gary