Question

如何将ACCESS中的数据求和后添加到VB中的文本框中。 ACCESS中的字段是金额，按日期对其求和然后放到text2

Answer 1

select A,sum(B) AS B合计,sum(C) AS C合计 form 表名 group A

Answer 2

select A,sum(B) AS B合计,sum(C) AS C合计 form 表名 group A