Tech Support Forum banner

Working with dates - Access 2003

939 Views 0 Replies 1 Participant Last post by  perryk1970
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
Status
Not open for further replies.
1 - 1 of 1 Posts
1 - 1 of 1 Posts
Status
Not open for further replies.
Top