SQL query with count
Posted on 2008-10-21
I am trying to write a sql query with a count result, and am running into a problem. It has been a while since I've written much sql, and am not sure if this is something that can be done in a single statement or not. I am trying to track the number of hits to a website, and determine the number of hits from different sites. I have a very basic table with colunms ConnectingSite (with values equal to SiteA, SiteB, SiteC, SiteD, or ExternalSite), ConnectingTime, and RemoteIPAddress. I am trying to query that table for the total number of connections from each site. I have tried to use COUNT (DISTINCT ConnectingSite) but have seen some information that Access doesn't support COUNT (DISTINCT ....), and am not even sure if that would work. Thanks in advance for any insight you can provide.