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