定義域集計関数で調べてみてください
ex.

IIf(DCount("*","Q勤務集計","氏名='"& [氏名] &"' AND 日付>" & Date()-Weekday(Date()) & " AND 所要時間>" & 10)>=2,"上限")
IIf(Dsum("所要時間","Q勤務集計","氏名='"& [氏名] &"' AND 日付>=" & DateSerial(Year(Date()),Month(Date()),1))>=100,"上限")
IIf(Dsum("所要時間","Q勤務集計","氏名='"& [氏名] &"' AND 日付>=" & DateSerial(Year(Date()),1,1))>=800,"上限")