当月的进项税fa piao统计,日期条件成功了,但只想统计有行里有“进项”的行的税额,小白新手不知怎么下手了。
Dim sx As DataCol = DataTables("fa piao管理明细表").DataCols("税项")
Dim bb As Integer
Dim yy As Integer = Date.Today.Year
Dim m As Integer = Date.Today.Month
Dim dt1 As new Date(yy,m,1)
Dim dt2 As new Date(yy,m,Date.DaysInMonth(y,m))
bb = DataTables("fa piao管理明细表").Compute("sum(税额)","开piao日期 >= #" & dt1 & "# and 开piao日期 <= #" & dt2 & "#")
[此贴子已经被作者于2017/11/25 14:59:06编辑过]