I have a recordset (rst) which I have created using an OpenRecordset Method on an existing table...call it t_Employee: Set rst = db.OpenRecordset("t_Employee", dbOpenDynaset) I want to be able to ...

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.