creating a log file with MS Access

[snipersix]

this is the SQL of my Append Query

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

 

[Rick Brandt]

this is the SQL of my Append Query

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

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());

 

[snipersix]

great now it works, thank you very much for your help