Prev: Function is not availalbe in expressions in query expression error
Next: Function is not availalbe in expressions in query expression e
From: Sabu on 4 May 2010 13:09
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.
From: vanderghast on 4 May 2010 16:04
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" <Sabu(a)discussions.microsoft.com> wrote in message
news:DD671F6B-1DB4-4B4A-88B0-61E5848C782D(a)microsoft.com...
> 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.

From: KARL DEWEY on 4 May 2010 16:08
>>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.
 | 
Pages: 1
Prev: Function is not availalbe in expressions in query expression error
Next: Function is not availalbe in expressions in query expression e