each "week" record just needs multiple sales fields, one for each year
the sale data could be stored, or unstored thru a relation
> each line will show a different year.
I have a table that has a record of sales for several years.
That's not quite clear. What kind of date information is there in this table?
It is a simple table... it has date, $ sales for the date, and some information about forms of payment.
From there the data can be sumirized into weeks of months or whatever.
What I want to do is a graph that shows the sales for diffent periods at the same time. Something like this...