G
Guest
I am using Access 2002. I have a crosstab query that is delivering the data
I want but am having a problem getting the results to show up the way I want.
I am returning a count of projects by Manager for each month in the data.
The data will store a rolling 12 months of data. Right now there is only
three months of data: months 11, 12 and 1. The month in this case for each
record is stored as: month/01/year. So the dates in the month column are
11/01/06, 12/01/06 ane 1/1/07. If I run the crosstab query it produces the
totals correctly. If I display the entire date, and have the sort order set
to ascendinig order, he order of the months is correct. However, what I want
to do is to have just the 3 character name of the month (Jan, Feb, etc)
display on the chart. If I format the month to produce what I want, the order
of the months is not corred.
I hope this makes sense. I need to know how to display the 3 character name
of the month and still keep the months in coronlogical order.
Any help is appreciated.
Mr B
I want but am having a problem getting the results to show up the way I want.
I am returning a count of projects by Manager for each month in the data.
The data will store a rolling 12 months of data. Right now there is only
three months of data: months 11, 12 and 1. The month in this case for each
record is stored as: month/01/year. So the dates in the month column are
11/01/06, 12/01/06 ane 1/1/07. If I run the crosstab query it produces the
totals correctly. If I display the entire date, and have the sort order set
to ascendinig order, he order of the months is correct. However, what I want
to do is to have just the 3 character name of the month (Jan, Feb, etc)
display on the chart. If I format the month to produce what I want, the order
of the months is not corred.
I hope this makes sense. I need to know how to display the 3 character name
of the month and still keep the months in coronlogical order.
Any help is appreciated.
Mr B