If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Filtering records by date
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. |
#3
|
|||
|
|||
Filtering records by date
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. |
Thread Tools | |
Display Modes | |
|
|