Function Not Available in Expressions in query expression date() 1

[3rdRail]

I'm using an append query that references a form for the data to be inserted into a table.

The only field that does not reference the form is DATE. I'm using the Date() function to insert a date stamp to the table. I have other databases that performs this without a hitch.

I'm not getting this error:

Function Not Available in Expressions in query expression date()

The query is appending to a .mdb on a file server.

Thanks in advance!

JB

 

[3rdRail]

Found the answer!

http://support.microsoft.com/support/kb/articles/q194/3/74.asp