Monthly reminders - Need a little help

thedude1971

Registered User.
Local time
Today, 09:13
Joined
Jun 16, 2011
Messages
10
Hi everyone,
I am trying to write two queries that will generate reminders for a staff member to action.

The first query will list any records, one month before they happen.

The second query will list any records, one week before they happen.

I have searched on the forums here and can't see anything I can use.

Any ideas? Thanks in advance.
 
In the critera for your datefield in the first query:

Between DateAdd("m",-1,Date()) And Date()

The second query:

Between dateAdd("w",-1,Date()) and Date()

JR
 
In the critera for your datefield in the first query:

Between DateAdd("m",-1,Date()) And Date()

The second query:

Between dateAdd("w",-1,Date()) and Date()

JR


Excellent, that works a charm. Thanks very much :-)
 

Users who are viewing this thread

Back
Top Bottom