Date in query doesn't work in Access 2003; did in 2000?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several queries with the expression in the criteria line of >Date()-#
(where the # sign is an actual number). These queries worked just fine in
Access 2000, but now that I have upgraded to 2003 I get the error message:
"Undefined function 'date' in expression.

How do I alter the expression to make it compatible with 2003?
 
It may be that Access 2003 has lost its marbles ... (oops, sorry, meant to
say "References").

Make a backup copy of the db.

Open a code module.

Select Tools | References.

Are any of the checked references prefixes with "MISSING"?

If so, note which one(s), uncheck it/them, save and close.

Re-open a code module, re-select Tools | References, re-check what had been
MISSING, close this window.

Select Debug | Compile ...

?Did it successfully compile?

If so, your "undefined" function is probably now defined.
 
Back
Top