date problem

[kevcar40]

hi
i have a table that contains a date the record was created
after three months i want to review the record and enter a review date
(no Problem so far)

i now query the table adding a field(test) that takes the review date
and adds 90 to it(3 months approx)

i have now another query that looks at the field test and compares it
to current date this is returning a record with a 22/01/2007 date
value, in the query i have used <date()

What i want is to return only the records that require reviewing
ie current date 25/10/2005 review date 24/10/2005
can anyone help please

thanks
kevin

[Keith]

"kevcar40" <ke******@btinternet.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

hi
i have a table that contains a date the record was created
after three months i want to review the record and enter a review date
(no Problem so far)

i now query the table adding a field(test) that takes the review date
and adds 90 to it(3 months approx)

i have now another query that looks at the field test and compares it
to current date this is returning a record with a 22/01/2007 date
value, in the query i have used <date()

What i want is to return only the records that require reviewing
ie current date 25/10/2005 review date 24/10/2005
can anyone help please

Hi Kevin, just a minor nit-pick but it would make your posting that much
easier to understand with some full stops and caps :o)

I've just simulated the scenario you describe and using "<Date()" for
criteria in the calculated field it appears to work correctly. Are you sure
you have the criteria against the right (calculated) field? Is your stored
date value a "date" data type in the table?

Regards,
Keith.
www.keithwilby.com

[Salad]

kevcar40 wrote:

hi
i have a table that contains a date the record was created
after three months i want to review the record and enter a review date
(no Problem so far)

i now query the table adding a field(test) that takes the review date
and adds 90 to it(3 months approx)

i have now another query that looks at the field test and compares it
to current date this is returning a record with a 22/01/2007 date
value, in the query i have used <date()

What i want is to return only the records that require reviewing
ie current date 25/10/2005 review date 24/10/2005
can anyone help please

thanks
kevin

Let's say you have a field called ReviewDate. In your query, you could
have
ReviewDate + 90
and in the criteria
<Date()