Sorting based on IDs

[accessLearn]

I have built a database in access where there is a date of shipment and the id of the product is generated by mm+yy-001 (incrementing 1) but the issue is the id was not being incrementing by 1 till 2015
So if the shipment was received in December 2014, the unique id would be 1214-001
and for Jan 2015, then id is 0115-001 , Feb 0215—01, March 0315-001 but from April 2015 the id has been incrementing by 1 , so march id is 0415-002 and May is 0515-003 and so on.
Now when I generate the report, I get all the 2015 records first and then December 2014 but I want to display December 2014 record first and then Jan 2015, Feb 2015 etc.
So the Ids are
1214-001
0115-001
0215-001
0315-001
0415-002
0515-003
0615-004
0715-005
0815-006
0915-007
1015-008
1115-009
And I want to display them in the same order.

How can I do that?

Thanks,


Blyzz

[RuralGuy]

How about creating a query that adds another field to sort on? That field could use one of the Date functions (DatePart,DateSerial,DateValue) to create an actual date from the ID field.