本文介绍了查询问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有我的桌子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]


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

07-21 00:40