vb + access sum 要怎么写?
在 vb + sql 中 如下所写,但是在ACCESS 中要怎么写。。。
SELECT 店铺,sum(case when 种类='月卡' then 金额入 else 0 end ) as j月卡, " & _
" sum(case when 种类='次卡' then 金额入 else 0 end ) as j次卡, " & _
" sum(case when 种类='杂费' then 金额出 else 0 end ) as j杂费, " & _
" sum(case when 种类='固定费' then 金额出 else 0 end ) as j固定费 " & _
" where 日期 >= # " & date1 & " # and 日期 <= # " & date2 & " # group by 店铺