Hi
Here's my problem.
Let's say i have a table which records whenever a user logs on to a
computer system.
So someone logs on and it records something like Fred, 10th March 2004
19:54
If Fred logs on again it will write another record to the database.
Same with Sally and Barbara and Bill and Jim etc.
So each user will have multiple records.
How do I do a query that shows me each user and the last time they
logged in (ie the highest LoggedIn value for that user).
By the way, if there's better ways to organise the data that's not an
issue as this is downloaded data I'm dealing with.
Many thanks
Al