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.

I've defined a simple select query in Access that retrieves data for a particular date. I execute the query from VBA.Is it possible to pass a parameter into the query from the VBA when I execute ...

Microsoft fixed a known issue occurring for Update queries in Click-2-Run and Windows Installer (MSI) editions of Access 2016, triggering errors when accessing databases and breaking functionality ...