monthly reports due

[Judy]

I'm trying to make a query to use in a VB module that will
alert the user that there is a report due on the 20th of
every month.

So the query simply needs to check if today's date is
within 10 days of the 20th of this month.

What would the expression for that be?

(or would it be easier to use VB code in the module I
wonder, and what would that code be?)

--Judy

 

[Douglas J. Steele]

In other words, if 10 <= Day <= 30 (except in February, I guess)?

WHERE Day(MyDate) BETWEEN 10 AND 30