strSql=SELECT Sum(reportCount) AS reportCountW, reporty, reportw FROM report GROUP BY reporty, reportw HAVING (reporty=Year(Date())) AND (reportw=DatePart('ww',Date()));
strSql=SELECT reportCount, reportID, reporty, reportw FROM report where (reporty=Year(Date())) AND (reportm=Month(Date())) AND (reportw=DatePart('ww',Date()));
|
||||||
|
|
![]() |
||
![]() |
Copyright
2006-2010 QuadRep Electronics [China] Ltd QuadRep Electronics [China] Ltd All Rights Reserved. | ![]() |