Due date and Reminder date

[Guest]

I want to display a date for which a report is due. I also want to display a
date about a week earlier to let the user know that the report is due.
Example: Report due 11/15/2006, due Alert 11/8/2006. What kind of expression
should I use and where do I input this data? thanks

 

[Jeff Boyce]

Where are you trying to do this displaying?

Where are you storing the "due date" for the report?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[fredg]

I want to display a date for which a report is due. I also want to display a
date about a week earlier to let the user know that the report is due.
Example: Report due 11/15/2006, due Alert 11/8/2006. What kind of expression
should I use and where do I input this data? thanks

The problem with returning just one date 7 days beforehand is that it
might fall on a non-business date and therefore will be missed.

This will remind the user of all reports due for the next 7 days.
Create a query and run it once a day.

SELECT tblBasicData.LastName, tblBasicData.DueDate, [DueDate]-Date()
AS DaysLeft
FROM tblBasicData
WHERE ((([DueDate]-Date()) Between 0 And 7));

 

[Guest]

In my table I have the due date column. I want them both to display in my
Form display.

 

[Guest]

That would be fine if the db was small but I'm gonna have a huge amount of
reports due all the time. What I wanted to to do was link the alert date (the
10 days prior date) with an email to be sent out for the Project managers. Is
that sort of thing possible without driving myself crazy. Obviously, I'm new
to Access.

I want to display a date for which a report is due. I also want to display a
date about a week earlier to let the user know that the report is due.
Example: Report due 11/15/2006, due Alert 11/8/2006. What kind of expression
should I use and where do I input this data? thanks

The problem with returning just one date 7 days beforehand is that it
might fall on a non-business date and therefore will be missed.

This will remind the user of all reports due for the next 7 days.
Create a query and run it once a day.

SELECT tblBasicData.LastName, tblBasicData.DueDate, [DueDate]-Date()
AS DaysLeft
FROM tblBasicData
WHERE ((([DueDate]-Date()) Between 0 And 7));

 

[fredg]

In my table I have the due date column. I want them both to display in my
Form display.

If all you want to do is display that information on a form, add an
unbound control to the form.
Set it's control source to:
=IIf([DueDate]-Date()=10,"Mail 10 day reminder","")
It will only appear on that exact 10th day before due.