Pro tip: Limit the number of records in an Access group Your email has been sent You don't need an expertise in SQL to limit the number of records in a group. With your user knowledge of queries and ...

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

I'm trying to come up with a query format that will allow me to return multiple rows of aggregate data grouped by DATE, but the date values would be BETWEEN certain intervals.<BR><BR>As in, the data ...