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 [Taiwan] Ltd Taipei office TEL: 886-2-26989933 Hsinchu office TEL: 886-3-5290090 QuadRep Electronics [Taiwan] Ltd All Rights Reserved. |
![]() |