Mulitple Group By in Query

[rooster]

i have a table including fields for date and IP address (amongst other things). I am trying to create a query to pull out number of unique IP addresses for each day.

can someone point me in the right direction?



(i am using access 2010)

[recyan]

Have you tried

SELECT
Date,
IPAddress
FROM
myTable
GROUP BY
Date,
IPAddress

Alternatively,
SELECT DISTINCT
Date,
IPAddress
FROM
myTable



Thanks

[rooster]

Thanks recyan

What i want is a count of distinct IPAddress for each day, not a list of distinct ips for each day. how do i do that?

[recyan]

Sorry, Missed out the "Number of" in your original post.

See if below gives some guidelines :

SELECT 
    qryDistinctDateIPAdrress.TheDate, 
    Count(qryDistinctDateIPAdrress.TheIPAddress) AS CountOfTheIPAddress
FROM 
    (
        SELECT DISTINCT 
            myTable.TheDate, 
            myTable.TheIPAddress
        FROM 
            myTable
    )
    AS 
    qryDistinctDateIPAdrress
GROUP BY 
    qryDistinctDateIPAdrress.TheDate;

Am assuming, the Date doesn't have a time factor in it.

Thanks

[rooster]

Thanks recyan, not so hard when you see it like that!