Access' conditional formatting feature is just as comprehensive, flexible, and powerful as Excel, but many users aren't aware it exists.

You don't need a complex set of expressions or even VBA to sort Access date values by specific components, such as month or year. Use DatePart() and sort on its results.