Okay what I need at end of the day is

Date # of transactions


Date # of unique ID's

For the first one I did it easy just a
SELECT ME.Date, Count(ME.Date) AS CountOfDate
FROM ME
GROUP BY ME;

But now I need to know the unique ID's
So right now the way im doing it is:
SELECT ME.[ME ID],ME.Date
FROM ME
GROUP BY ME.[ME ID], ME.Date
HAVING (((ME.Date)=#2/2/2009#));

Then I just do a count on the list generated back. But it would speed things up if i got this:

date unique total
2/2/2009 1500 50000
3/2/2009 4500 45000
...
15/2/2009 3223 32000

any ideas?