If (Month(DMax("[DataTabCal]", "[TblTabCal]", "[BlnDay] = True AND [DataTabCal] < #05/01/2010#")) = 5) Then
MsgBox DMax("[DataTabCal]", "[TblTabCal]", "[BlnDay] = True AND [DataTabCal] < #05/01/2010#")
Else
MsgBox DMin("[DataTabCal]", "[TblTabCal]", "[BlnDay] = True AND [DataTabCal] > #05/01/2010#")
End If
|