date problem

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

"kevcar40" <kevcar40@btinternet.com> wrote in message
news:1130249184.335712.271310@g47g2000cwa.googlegr oups.com...[color=blue]
> 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
>
>[/color]
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

kevcar40 wrote:
[color=blue]
> 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
>[/color]
Let's say you have a field called ReviewDate. In your query, you could
have
ReviewDate + 90
and in the criteria
<Date()