查询问题 [英] Query issue

问题描述

我有我的桌子MAIN OPS TABLE。 我有以下行消息来源：事件名称，事件类型，操作完成后，事件日期。 我需要我的查询，在具有COUNT个事件名称时对事件类型进行分组。 我有一个标准
for After Action Complete为TRUE。 所有这些信息都必须在事件日期WHERE> = [输入开始日期]和< = [输入结束日期]的日期参数范围内。 谢谢。

I have my table MAIN OPS TABLE.  I have row sources of the following: Event Name, Type of Event, After Action Complete, Event Date.  I need my query to group the Type of Event while having a COUNT of Event Name.  I have a criteria for After Action Complete as TRUE.  All of this information needs to be within a date parameter for Event Date WHERE >=[Enter Start Date] AND <=[Enter End Date].  Thanks.

推荐答案

嗨Mathis，

Hi Mathis,

您的查询是否与此类似？

Does your query looks something similar to this?

SELECT [事件类型]，计数（*）AS TotalEvents

FROM [MAIN OPS TABLE]

WHERE [行动完成后] ] = TRUE

 和[事件日期] [输入开始日期]和[输入结束日期]之间

GROUP BY [事件类型]

SELECT [Type of Event], Count(*) AS TotalEvents
FROM [MAIN OPS TABLE]
WHERE [After Action Complete]=TRUE
 AND [Event Date] Between [Enter Start Date] AND [Enter End Date]
GROUP BY [Type of Event]

这篇关于查询问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！