MS access query to count number of call on particular date.
ASP.NET
1
Posts
1
Posters
0
Views
1
Watching
-
query to count the total number of call performed on a particular date and display it on gridview. My table is
date userid time
1/2/2012 1 20
1/2/2012 2 10
1/2/2012 1 30
1/2/2012 1 15
1/2/2012 1 5
2/2/2012 2 10
2/2/2012 1 20
2/2/2012 2 10and i want data in this format
date userid time No. of calls
1/2/2012 1 70 4
1/2/2012 2 10 1
2/2/2012 1 20 1
2/2/2012 2 20 2Time is addition of total number of call time and no. of calls is the addition of calls received by user on a particular date. P.S. Using VS 2013 Framework 4.5 ASP.NET c#, backend MS ACCESS