most acitve users

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hello,

i am searching for two sql scripts -> both for a Access DB:

first one (the simple one): 
all user with their number of posts:

SELECT A.Username, COUNT(T.Author_ID) FROM tblAuthor A,  tblThread T 
WHERE A.Author_ID = T.Author_ID 
GROUP BY A.Username 
ORDER BY COUNT(T.Author_ID) DESC

second one:
all user with their number of posts between a date:

SELECT A.Username, COUNT(T.Author_ID) FROM tblAuthor A,  tblThread T 
WHERE A.Author_ID = T.Author_ID 
AND T.Message_Date BETWEEN #01/06/2005# AND #30/06/2005# 
GROUP BY A.Username 
ORDER BY COUNT(T.Author_ID) DESC

The first script is working fine - but the second one wont bring the correct result. Can anyone take a view about it?