Your users shouldn't have to manually type the current date over and over into an Access form. Save them some time and effort by automating the process. Are your users frequently typing today’s date ...

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 ...