Pleae,Please help

  • Thread starter Thread starter Carly
  • Start date Start date
C

Carly

Hi,
I have a table that lists jobs done on a certain date. I
want to create a query or report that will remind me to
do the job again in 7 days.Please help a helpless or is
that hopeless girl. thank-you in anticipation.
 
Carly,
You can create a new field in your query:

Nextdate:dateadd("d",7,yourdate)
criteria set to Date()

This will return any jobs where 7 days added to the date
it was last done is equal to today's date.
 
Hi,
I have a table that lists jobs done on a certain date. I
want to create a query or report that will remind me to
do the job again in 7 days.Please help a helpless or is
that hopeless girl. thank-you in anticipation.
Click to expand...

Carly, could you give us a bit of help so we can help you? What is the
structure of your table? What sort of "reminder" do you want?

The short answer is that to see a display of all jobs which were done
last Wednesday (exactly seven days ago) you could create a Query based
on your table with a criterion on the date field of

=DateAdd("d", -7, Date())

This would not show jobs done eight days ago or six days ago, just
those done on that one day - so if you had a job run one week before a
holiday, you'ld miss it. Not sure if that's what you want!
 
Back
Top