用ACCESS表达式如何现实按条件统计功能

2024-11-22 04:49:56
推荐回答(2个)
回答1:

sql="select sum(日利润) from tablename where month(日期)="&month(date())&""

回答2:

select sum(profit) from t where datefield between #开始日期# and #结束日期#