For Each s As String In t.DataTable.GetValues("支出类型", "支出类型 is not null")
Dim sum = t.DataTable.compute("sum(支出金额)", "支出类型='" & s & "'")
改成
Dim d As Date = new Date(Date.Today.Year, Date.Today.Month, 1)
For Each s As String In t.DataTable.GetValues("支出类型", "支出类型 is not null and 支出日期 >= #" & d & "# and 支出日期 < #" & d.AddMonths(1) & "#")
Dim sum = t.DataTable.compute("sum(支出金额)", "支出类型='" & s & "' and 支出日期 >= #" & d & "# and 支出日期 < #" & d.AddMonths(1) & "#")