Sum and Count function

amator

Registered User.
Local time
Today, 02:55
Joined
Aug 1, 2006
Messages
23
Hi
I have a table where is listed all happened faults from a month period. Every fault have start time and end time field and ip field which tells what device has been "broken". Now I'am trying to calculate how many faults has happened in every day. I have make a query from the table which looks like this:
"SELECT (DateValue(Table.[start time])) AS date, Count(Table.[IP adress]) AS [faults happened]
FROM Table
GROUP BY Table.[start time], Table.[IP adress];"
And I get this:
date faults happened
12.8 2
12.8 1
12.8 1
13.8 3
..
But how I can make my query count together how many faults has happened in every day? So it should look like this
date faults happened
12.8 4
13.8 3
..
 
Last edited:
Code:
SELECT COUNT(date) FROM(SELECT (DateValue(Table.[start time])) AS date, 
         Count(Table.[IP adress]) AS [faults happened]
FROM Table
GROUP BY Table.[start time], Table.[IP adress];)
 

Users who are viewing this thread

Back
Top Bottom