Filtering records by date

Yea I'm trying to filter a table that has specific due dates, but I want to
run a query that will show the results 7 days before the due date and not
show all the records just the records that have the due date 7 days prior to
the due date. Also wondering if anyone knows how to make it where the query
could send an email notifier to people when a record hits the 7 day prior to
the due date mark? Thank you for all your guys time.

A criteria under the DueDate like:

= Date( ) AND Date( ) + 8


should display only the records where DueDate value is today or later, but
not those more than 7 days in the future.



Vanderghast, Access MVP



"Sabu" wrote in message
news
Yea I'm trying to filter a table that has specific due dates, but I want
to
run a query that will show the results 7 days before the due date and not
show all the records just the records that have the due date 7 days prior
to
the due date. Also wondering if anyone knows how to make it where the
query
could send an email notifier to people when a record hits the 7 day prior
to
the due date mark? Thank you for all your guys time.

just the records that have the due date 7 days prior to the due date.
Huh? How to have 7 days before itself?

Maybe you want this --
Due in 7 days: [Due Date]
= Date()-7

--
Build a little, test a little.


"Sabu" wrote:

Yea I'm trying to filter a table that has specific due dates, but I want to
run a query that will show the results 7 days before the due date and not
show all the records just the records that have the due date 7 days prior to
the due date. Also wondering if anyone knows how to make it where the query
could send an email notifier to people when a record hits the 7 day prior to
the due date mark? Thank you for all your guys time.