I have a simple query which looks at one particular date field within my table and gives me any records whose dates in this field are within 60 days of the current date. I am using access 97 with windows 2000. I copy the database over to a laptop which has just been converted to windows 2000 and the query gives me an error.
The sql for the query is
SELECT tblchurchsuggestions.*
FROM tblchurchsuggestions
WHERE (((tblchurchsuggestions.lastupdate)>Date()-60));
When running the query I get the following error.
Function isn't available in expressions in query expressions '(((tblchurchsuggestions lastupdate)>Date()-60))'
I think it has something to do with the object browser or reference library, but I cannot find the solution. Any help would be appreciated. Thanks.
The sql for the query is
SELECT tblchurchsuggestions.*
FROM tblchurchsuggestions
WHERE (((tblchurchsuggestions.lastupdate)>Date()-60));
When running the query I get the following error.
Function isn't available in expressions in query expressions '(((tblchurchsuggestions lastupdate)>Date()-60))'
I think it has something to do with the object browser or reference library, but I cannot find the solution. Any help would be appreciated. Thanks.
