You can get the day of the week (as a number) using the DatePart function.
It returns a value of 1 to 7, depending on the day of the week and on which
day you designate as the first day of the week (it defaults to Sunday as day
1 otherwise). For example,
?DatePart("w", #7/31/2005#)
1
?DatePart("w", #7/31/2005#, vbSunday)
1
?DatePart("w", #7/31/2005#, vbMonday)
7
Thus, you can use the absence dates as the source date for the DatePart
funcion. And your query can use the result to group the query's output.
--
Ken Snell
<MS ACCESS MVP>