I have a table in Access2000 (tblLogins) that has 2 columns, one with Login Details (Login) and the other with User ID's (Username)
e.g.
Login Username
20020729082158 Admin
20020729082258 Admin
20020729082420 Admin
20020729083500 Tester
20020729083539 Tester
20020729110013 Tester
What I am trying to do is extract the last login details for each user to another table using VBA
Any assistance would be greatly appreaciated.
Rgds,
S.
e.g.
Login Username
20020729082158 Admin
20020729082258 Admin
20020729082420 Admin
20020729083500 Tester
20020729083539 Tester
20020729110013 Tester
What I am trying to do is extract the last login details for each user to another table using VBA
Any assistance would be greatly appreaciated.
Rgds,
S.