Date query

  • Thread starter Thread starter hem
  • Start date Start date
H

hem

Hi! I would like to know how to incorporate a criteria or code in a query
that checks the date field if its already been >=3months from the present
date to a button? so when I press the cmd button it will automate and gives
me a list of entries that needs to be updated. I have been checking a couple
of discussions here and whenever I try to use the other syntax (e.g. IFF,
Where, Date() and many more) that is close to what i need then it always
gives me a wrong list or somtimes wrong parameters.

ex.
Part Number Description Rev. Date Updated
02-766371-02 PWA GATE DRIVE Any rev. ok 08/28/08
02-786489-10L PWA GATE BASE GEN LGS Any rev. ok 05/10/08
02-786495-01 PWA INV BASE DRIVE 5-9 ok 08/06/08

if date updated is >=90days or 3months then display all list.

thanks in advance!
 
Bob,

Great it worked! i was mowrking the other way around using > instead of <. i
think my logic is a bit rusty! thanks!

raskew via AccessMonster.com said:
Hi -

Create your query then, while in query-design mode, place this in the
criteria cell of your [Date Updated] field:
<=Date()-90

The query builder will complete the WHERE statement and you should
be good to go.

HTH = Bob
Hi! I would like to know how to incorporate a criteria or code in a query
that checks the date field if its already been >=3months from the present
date to a button? so when I press the cmd button it will automate and gives
me a list of entries that needs to be updated. I have been checking a couple
of discussions here and whenever I try to use the other syntax (e.g. IFF,
Where, Date() and many more) that is close to what i need then it always
gives me a wrong list or somtimes wrong parameters.

ex.
Part Number Description Rev. Date Updated
02-766371-02 PWA GATE DRIVE Any rev. ok 08/28/08
02-786489-10L PWA GATE BASE GEN LGS Any rev. ok 05/10/08
02-786495-01 PWA INV BASE DRIVE 5-9 ok 08/06/08

if date updated is >=90days or 3months then display all list.

thanks in advance!
Click to expand...
Click to expand...
 
Back
Top