access指定年月之后查询_Access如何按年，月，日，周，季查询

String sql = "select count(*) as mynum from Trade group by format(StockDate, 'yyyy-MM')";

这是按月查询的，其他以此类推。

日：

SELECT SJoinTime, ID FROM Sale where format(sjointime,'yyyy-MM-dd')=#2009-03-30#

另外可用datepart函数：

DatePart 函数

返回一个 Integer 值，其中包含给定 Date 值的指定组件。

Public Overloads Function DatePart( _

ByVal Interval As DateInterval, _

ByVal DateValue As DateTime, _

Optional ByVal FirstDayOfWeekValue As FirstDayOfWeek = VbSunday, _

Optional ByVal FirstWeekOfYearValue As FirstWeekOfYear = VbFirstJan1 _

) As Integer

－ 或 －

Public Overloads Function DatePart( _

ByVal Interval As String, _

ByVal DateValue As Object, _

Optional ByVal DayOfWeek As FirstDayOfWeek = FirstDayOfWeek.Sunday, _

Optional ByVal WeekOfYear As FirstWeekO