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. When grouping date values at ...
When you create a Microsoft Access table, Access will automatically create a primary key to your database table. Still, you can also specify the field you want as the primary key for your database ...