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.As in, the data would ...

I currently have a query (in MS Access) that looks like thisSELECT (Format([clicktime],"ddddd hampm")) AS clickhour, Count([clicks].[clicktime]) AS clickcount FROM ...