Undefined function 'Date' in expression

[Edgemire]

While running an append query that makes use of the today's date function 'Date()', I encounter the following error "Undefined function 'Date()' in expression" when I try to run the query. The problem with this error is that it appears on some computers, but not others, despite the fact that all the computers are running the same database on the company's network.

Any suggestions would be greatly appreciated.

 

[JoeMiller]

The references on the machine(s) in question are missing. Go to a code window, click Tools-->References and replace the ones with MISSING:

HTH Joe Miller
joe.miller@flotech.net