[thelist] Last Login Time SQL
Noah St. Amand
noah at tookish.net
Tue Jan 9 16:45:20 CST 2007
Thanks everyone for your help with this.
I should have mentioned in my original post that the log table contains
all logins, not just the most recent, which was what was causing me
problems. What put me on the right track was MAX, which Tim suggested.
Access doesn't permit MAX in a WHERE clause, so I had to jump through
some hoops to make it work, but it's still much more efficient than
before I was using MAX.
Thanks again.
Cheers,
Noah
More information about the thelist
mailing list