OWC chart. Categories=dates

[Victoria]

Hi all,
I use OWC chart and the source for it is recordset in my access db.
The chart has dates for categories and I would like to format it as
mmyy, but in that case I failed to sort the dates properly... the only
thing that works fine is using DateSerial function, but in this case
dates look as ddmmyyyy..... too long for chart If I try to use
Format( DateSerial... - again the problems with sorting....
please help!
Victoria

 

[KARL DEWEY]

Use two - sort on DateSerial and use Format in display.