来自多个领域的一个总计 [英] One Total from multiple Fields

问题描述

大家好，我知道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

推荐答案

嗨尼克，


试试这个...

Hi Nick,

Try this ...

展开 | 选择 | Wrap | 行号

嗨尼克，


试试这个...

Hi Nick,

Try this ...

展开 | 选择 | Wrap | 行号

非常感谢M这很棒。

我非常感谢你的帮助。

Nick

Thank you very much "M" that worked great.
I really appreciate the help.
Nick

没问题尼克


不客气


Mary

No problem Nick

You''re welcome

Mary

这篇关于来自多个领域的一个总计的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！