creating a log file with MS Access

S

snipersix

this is the SQL of my Append Query

INSERT INTO LogFile ( UserName, TimeLogged )
VALUES (CurrentUser, Now());
 
R

Rick Brandt

snipersix said:
this is the SQL of my Append Query

INSERT INTO LogFile ( UserName, TimeLogged )
VALUES (CurrentUser, Now());
Click to expand...

CurrentUser is a function so you need the () on the end just like you have after
Now().

INSERT INTO LogFile ( UserName, TimeLogged )
VALUES (CurrentUser(), Now());
 
Top