问题描述
我有我的桌子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.
推荐答案
您的查询是否与此类似？
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]
这篇关于查询问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！