[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