Sasi Reddy

Sasi Reddy

  • NA
  • 346
  • 220k

query with agrregate function

Sep 9 2014 12:23 AM
The table structure like this
 
Cr_By     Date
1              2014-09-09 04:40:57.463
 1             2014-09-09 04:55:10.700
 
 
 
 
sSql = " SELECT *FROM WF_Dailyreport WHERE DATEPART(yyyy, WF_CrOn) = " & year & " AND DATEPART(mm, WF_CrOn) = " & month & " AND WF_CrBy=" & crby & "" 
 
If i select the user and month and year for above query i am getting both rows 
 
 
but i need count as 1
how to get that count?..
please tell me.. 

Answers (4)