Can anyone tell me why this doesn't work?
DoCmd.RunSQL ("INSERT INTO tblLog ( UserID, LoginDate, LoginTime, DB") _
& "SELECT tblLogin.UserID, tblLogin.LoginDate, tblLogin.LoginTime, 'SOL' AS 'DB'" _
& "FROM tblLogin"
Thank you.
DoCmd.RunSQL ("INSERT INTO tblLog ( UserID, LoginDate, LoginTime, DB") _
& "SELECT tblLogin.UserID, tblLogin.LoginDate, tblLogin.LoginTime, 'SOL' AS 'DB'" _
& "FROM tblLogin"
Thank you.