monthly reports due

  • Thread starter Thread starter Judy
  • Start date Start date
J

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
 
In other words, if 10 <= Day <= 30 (except in February, I guess)?

WHERE Day(MyDate) BETWEEN 10 AND 30
 
Back
Top