I am working with tables that contain 13 months of data.
The tables are updated monthly with the previous 13 months of data.
The tables are designed with each line being a month of data with the columns each containing a different piece of data, i.e. dollars spent, Percent of target, etc. (The Month is formatted as MM/DD/YYY)
As an example, the data I am working on currently is from 02/01/2010 through 02/01/2011 - Next month the data will be from 03/01/2010 Through 03/01/2011
What I need to do is create a query that will make the first month of the report be labled as "Month 1" the 2nd month "Month 2" etc up to "Month 13"
I would like for this to update each month as I get a new "13 Months" worth of data.
thanks PerryK1970