Hi,I have this SQL (it's going with ASP and an access database):sql = "SELECT artist, count(artist) AS artist_count, [date] FROM song GROUP BY artist WHERE [date] > " & DateAdd("ww", -1, Date) & " ORDER BY count(artist) DESC"And my DB schema is song(id,artist,song,date,time).I want it to group all rows with a certain artist and count how many occurances there are, but only if the date is logged in the past week. Without the [date] selection and WHERE clause, it works perfectly fine, but selecting [date] along with the other two returns: "You tried to execute a query that does not include the specified expression 'date' as part of an aggregate function."Any ideas?I appreciate any help,Thanks,Matt