查询过滤结果？ [英] Query Filtering Results?

问题描述

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

我有一个非常简单的查询，即"公司信息"。 "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

解决方案

Hi Steven,

I am afraid it is difficult to understand your requirement. I would suggest you share us your Table Design and Table records, your current query and the expected result you want by query.

Best Regards,

Edward

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