Reminder based on date 1 week / 1 month from now 1

[SeadnaS]

How would I create a reminder to show how many of my records date fields are within 1 week or 1 month from now (in the future) I want to show a list on my form showing how many records due dates are within a month and within a week.

Finding it hard to find info on how to do this, any help much appreciated!

 

[PHV]

A starting point (SQL code):

SELECT Count(*) AS HowManyW
FROM yourTable
WHERE [your due date field] BETWEEN Date() And DateAdd("w",1,Date())

SELECT Count(*) AS HowManyM
FROM yourTable
WHERE [your due date field] BETWEEN Date() And DateAdd("m",1,Date())

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SeadnaS]

Wow a lot simpler than i thought it would be! So these queries are listing how many records are less than a week/month away. Is this correct?