i am trying to sort my report by year. however, the format of the year is different than you would expect. the format is YY### (the # are a project number unrelated to the sorting). i am trying to get the report to sort by the year from NEWEST to OLDEST. for example, i want to sort from 06### to 76### in that order. i can get it to sort from the 90's to the 70s, but it leaves the 00's at the bottom.
any ideas?! any solutions?! please help!!
thanks
That's what all that Y-2-K thing was about. Unfortunately, without seeing all your tables and data, the thing I would do (probably not the right thing to do, but it would work):
To the table that contains your "06###" field, add another field to hold the 4-digit year associated with it.
THEN add that field to the query your report is based on.
THEN, in your report, sort by the year field FIRST, then your "06###" field.
I think that would do it. The snag of course is that when you add a new record, you'll have to add the year in that extra field.
Don't know if this helps...