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

Despite the Date/Time data type and a selection of functions for manipulating date values and components, handling dates in Access is often a little tricky and nonintuitive. These tips will help you ...

Does anyone know of a handy function in Access that will take 2 dates and return the number of weekdays between them? Business days would actually be even better (not counting things like July 4), but ...