Since you tagged your question as VB.Net, I understand that you dont need a T-SQL query to answer your question.
I dont know in which point you had difficulty though;
Your steps as follows;
Create a table with the fields of , ID, UserID, UserName, LoginTime if you need you can link this table with your Users table and use UseriD as a foreign key.
In your login page. Connect to your DB, and make a insert query to the specified table. Something like
Try
Mycn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=[your db].mdb;")
Mycn.Open()
SQLstr = "INSERT INTO Table1 (field1, field2,field3) VALUES('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "')"
Command = New OleDbCommand(SQLstr, Mycn)
icount = Command.ExecuteNonQuery
MessageBox.Show(icount)
Catch ex As Exception
MsgBox(ex)
Mycn.Close()
End Try