问题描述
大家好,我知道Access相当不错,但我对SQL非常非常弱。我有一个非常大的表,我需要从多个字段中提取一个总计。我已经创建了一个单独的SUM所有字段的查询,但我不知道如何添加所有字段总数以获得一个总计。以下是我查询中的4个字段作为示例。
SELECT
总和([环境回合]。[灭火器])AS [SumOfFire灭火器],
总和([环境回合]。[火灾退出])AS [SumOfFire退出],
总和([环境回合]。[火警]] AS [SumOfFire报警],
总和([环境回合]。[疏散地图])AS [SumOfEvacuation Map]
来自[环境回合];
请在编程帮助中具体说明如果可以,就像我说的那样,我在这方面很弱。
谢谢,
Nick
Hello everyone, I know Access fairly well, but I am very, very weak on SQL. I have a very large table that I need to pull a grand Total from multiple fields. I have created a query to SUM all the fields individually, but I do not know how to add all the field totals to get one Grand Total. Here are 4 fields from my query as an example.
SELECT
Sum([Environmental Rounds].[Fire Extinguishers]) AS [SumOfFire Extinguishers],
Sum([Environmental Rounds].[Fire Exits]) AS [SumOfFire Exits],
Sum([Environmental Rounds].[Fire alarms]) AS [SumOfFire alarms],
Sum([Environmental Rounds].[Evacuation Map]) AS [SumOfEvacuation Map]
FROM [Environmental Rounds];
Please be specific in the programing help if you can, like I said, I am very weak in this area.
Thank you,
Nick
推荐答案
没问题尼克
不客气
Mary
No problem Nick
You''re welcome
Mary
这篇关于来自多个领域的一个总计的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!