ACC2000 Month-Year sort in charts

  • Thread starter Thread starter BrentDA
  • Start date Start date
B

BrentDA

I've read several of the posts about Date sorting, but nothing seems to fit
my situation.

I have a table of statistical data with a date column (called MthDte) for
3-letter month, 2-digit year entry, e.g., Jan 08, Feb 08, Mar 08, etc. The
Data Type for that field is set to Text rather than Date, since I didn't want
an actual date in the format, just Month & Year.

I set up a chart report (showing the Data Table, and it looks great in
Design mode. However, in Print Preview mode, it is sorting the months (top
row of Data Table) alphabetically rather than chronologically.

The Row Source for the chart properties has the following:

SELECT [MthDte],Sum([TDPM]) AS [DPM],Sum([TTTLUNTSPRD]) AS [Total Units
Produced],Sum([TTND]) AS [Total Number of Defects],Sum([TGOAL2007]) AS [GOAL
2007],Sum([TGOAL2008]) AS [GOAL 2008] FROM [tbl02726DPM2008] GROUP BY
[MthDte];

How do I get the month/year in the top row of the Data Table to sort
chronologically rather than alphabetically.

Thanks for your help !

Brent
 
You need to include a real date field in your row source to sort by. You
don't have to display it. You can format the date field to something like
Format(DateField,"yyyy-mm")
 
Back
Top