个小问题
但很不幸
是在Access中没有直接
支持(Excel中有个现成:NETWeekdays)
所以非得自己做点开发第
步:创建个自定义Public Function WeekDayCount(firstDate As Date, LastDate As Date) As Integer
'计算工作日天数
On Error GoTo Err:
Dim i As Integer
Dim TempDate As Date '临时日期
Dim Tempts As Long
Tempts = DateD
f("d", firstDate, LastDate)
For i = 0 To Tempts
TempDate = DateAdd("d", i, firstDate)
Select Case Format(TempDate, "w")
Case 2, 3, 4, 5, 6
WeekDayCount = WeekDayCount + 1
End Select
Next
Err:
Exit Function
End Function 第 2步:然后在查询中使用如下语句
SELECT WeekDayCount(开始日期,结束日期) AS 工作日天数, *
FROM orders;
最新评论