OK, so to get that most recent monday:
[MaxDate]-Weekday([MaxDate],2)
This works correctly, but when I put it in the dsum fuction as such:
=DSum("[HoursDetail]","qryHoursDetail","[HoursDate]" >[MaxDate]-Weekday([MaxDate],2))
it returns nothing. Any suggestions?