based on a suspense date how can I get future dates to send remind

[Artic Newbee]

I am trying to send out an auto email to the supervisors to remind them to
conduct feedbacks prior to thier suspense dates. So if the suspense date is
30 Jan 05, I would like a reminder sent out on 7 Jan 05, and 15 Jan 05. What
I am ending up with are dates that are in the wrong year and not within 15
days of suspense. Thank you in advance for any help, reading the
discussions, I am an obvious novis who desperately needs help.

 

[John Vinson]

On Wed, 4 Jan 2006 22:52:02 -0800, Artic Newbee <Artic

I am trying to send out an auto email to the supervisors to remind them to
conduct feedbacks prior to thier suspense dates. So if the suspense date is
30 Jan 05, I would like a reminder sent out on 7 Jan 05, and 15 Jan 05. What
I am ending up with are dates that are in the wrong year and not within 15
days of suspense. Thank you in advance for any help, reading the
discussions, I am an obvious novis who desperately needs help.

What's the logic? Why the 7th, why the 15th? What's the structure of
your table? What query or code did you use that's generating the wrong
dates?

You can see your database. We cannot!

John W. Vinson[MVP]

 

[John Vinson]

On Wed, 4 Jan 2006 22:52:02 -0800, Artic Newbee <Artic

I am trying to send out an auto email to the supervisors to remind them to
conduct feedbacks prior to thier suspense dates. So if the suspense date is
30 Jan 05, I would like a reminder sent out on 7 Jan 05, and 15 Jan 05. What
I am ending up with are dates that are in the wrong year and not within 15
days of suspense. Thank you in advance for any help, reading the
discussions, I am an obvious novis who desperately needs help.

If you want to send out an email fifteen (not fourteen? do you want
this to run on weekends??) days prior to SuspenseDate, use a Query
with a criterion on SuspenseDate of

DateAdd("d", 15, Date())


John W. Vinson[MVP]

 

[Artic Newbee]

My supervisors have 30 days to perform feedbacks, my thought process is that
if I can send them 2 reminders, the first 7 days into the 30 days and then
another 14 days into that 30 days, I will be able to reduce the late
suspenses out of our office.

I was trying to query a table that has dates of the required reports. I
figured that if I did a query that would take the due date of the report and
have it automatically calculate 30 from that date and let me know if the
report was due within the next month. In my query for the report date I have
tried various expressions with the one coming close to what I want is

=Date() + 30 . The problem with this expression is that it is coming back

with a date that isn't due until Jan 07, also one that is due until May of
this year.

Thank you for responding.