英文:
how to sum values in access with repeating unique keys
问题
我正在尝试将每个唯一的键（在左侧）对应于来自三个城市的单个值总和。我尝试使用sum函数和查询设计中的totals，但没有成功，出现错误。
英文:
I am new to access. I an trying to add the values together so that each unique key (on the left) corresponds to a single value sum from the three cities.
I have tried using sum function and totals in query design, didn't work and gave error.
答案1
得分: 1
尝试这样做，忽略第三列：
选择 [列1]，汇总([列2]) 作为 总计
从 您的表
按 [列1] 分组
英文:
Try this, ignoring column 3:
Select [Column1], Sum([Column2]) As Total
From YourTable
Group By [Column1]
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论