Showing last 7 days records in asp page

I have a page.. written in ASP/VBscript... and i need a SQL Query to retrive last 7 days records... and if possible.. find out the total number of records for each day ie. 1st, 2nd, ... 7th etc.

any idea how i can write the SQL query for that.. btw.. the database is MS Access database..

This should get you the last 7 days records

SELECT  * FROM  tblThread WHERE (DATEDIFF(d, Message_date, Now()) <= 7)

Replace tblthread with you table name and message_date with your Date Field name. Ive only tested it on SQL server but i cant see why it wont work with access.

Your second question stumps me as i cant see an efficient way of doing it.

for the second.. but i don't know if it will be good to use... u can add recordcount.. and then use:

SELECT  * FROM  tblThread WHERE (DATEDIFF(d, Message_date, Now()) = 1)

and i = r.RecordCount (where i and r are......)

then SELECT  * FROM  tblThread WHERE (DATEDIFF(d, Message_date, Now()) =2 )

and i = r.RecordCount

n.b. will be wonderful if this made in a loop.. ranges from 1 to 7.... WOW

and so on