查询过滤结果？

问题描述

您好，我需要再次提供帮助！

我有一个非常简单的查询，即"公司信息"。 "Open Opps" "赢得奥普斯" "总赢" "总开放"。 打开的opps和赢得的opps是复选标记。 赢得总额和总开放总额为
总和。

我想告诉查询根据哪个复选标记找到打开opps的结果和赢得opps的总数检查。

我正在运行查询报告，我与老板一起审核并希望每个人都有总计。

我的表运行查询总计所有作业的总和。

我在设计视图中写什么表达式赢得/总打开字段告诉他们只为每个计算相应的CHECK框？

谢谢，

史蒂文

解决方案

Hello, I need help again!

I have a very simple query that is pulling in "Company Info" "Open Opps" "Won Opps" "Total Won" "total Open".  the open opps and the won opps are check marks.  The total won and total open are total sums.

I want to tell the query to find the results of open opps and totals of the won opps based on which check mark is checked.

I am running a report off the query that I review with my boss and want to have totals for each.

My table running the query is totaling the totals for all jobs combined.

What expression do I write in the design view Total won / Total Open fields to tell them to ONLY calculate corresponding CHECK boxes for each?

Thanks,

Steven

解决方案

这篇关于查询过滤结果？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！