Monthly reminders - Need a little help

[thedude1971]

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.

 

[JANR]

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

 

[thedude1971]

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