K
KlausAlt
I tried once before, but didn't ask the right question. Here is what I
have. I have a query and one of the fields that is in the query is a
date field. The date that is expressed is the date that a certain
document was issued on. The documents expire in one year, so I want to
run a query that will give me the expired documents. I tried several
different ways, and the only way so far I have been able to do this
using this command: Between #2/1/2004# And #4/1/2005# in the criteria
field. I have tried :>Date()+365, ate()>365 with no success.
What I want the query to do is pull up all records older than one year
from date of issue. The above command gives me all the records that
expired from February 04 to April of 05, which works. However, I have
to change the criteria each month to get my report. Any ideas would be
much appreciated.
Thanks.
have. I have a query and one of the fields that is in the query is a
date field. The date that is expressed is the date that a certain
document was issued on. The documents expire in one year, so I want to
run a query that will give me the expired documents. I tried several
different ways, and the only way so far I have been able to do this
using this command: Between #2/1/2004# And #4/1/2005# in the criteria
field. I have tried :>Date()+365, ate()>365 with no success.
What I want the query to do is pull up all records older than one year
from date of issue. The above command gives me all the records that
expired from February 04 to April of 05, which works. However, I have
to change the criteria each month to get my report. Any ideas would be
much appreciated.
Thanks.