Access – sort by month

by susanakil . Updated 24 years, 4 months ago

I have a database that a user enters a tracking number, example DEC009. The record is called by this tracking number. How can I sort records by month such as:

Jan001
Jan002
Mar011
Dec009