Problems with Date() and Time()

[hays]

Hi

I've been trying to fix a co-worker's database. The original problem was an absense of dll files on his new computer but I *think* that I have set up the necessary ones.

A query of his is simply:

UPDATE
DISTINCTROW Last_Import
SET Last_Import.Import_ID = Date() & " " & Time();


and an error is showing which is:

Function isn't available in expressions in query expression 'Date() & " " & Time()'

What am I missing? Thanks in advance.

 

[jimmythegeek]

Try this:

UPDATE Last_Import SET Import_ID = Now();


Jim Lunde
compugeeks@hotmail.com
Custom Application Development