查询中的计算 - 苦苦挣扎!!!! [英] Calculations within a Query - Struggling!!!!

问题描述

我有2个表，其中包含similair信息，我有一个查询运行然后总计几个列的总和，我想运行另一个查询，将创建一个列，其中包含第一个查询列的2个如果这是有意义的话，我认为它就像是一样简单

colum1：query1.SumOfGoals / query1.SumOfApperances

但这不行，有人可以帮忙!!!!

解决方案

尝试：

colum1：[query1]。[SumOfGoals] / [query1]。[SumOfApperances]


在这个新查询中使用你的查询和总和！


:)

我有2个表可以保存similair信息，我有一个查询运行然后总计几个列的总和，我想运行另一个查询，将创建一个包含第一个2的列查询列如果有意义则相互划分，我认为它就像例如一样简单

colum1：query1.SumOfGoals / query1.SumOfApperances

但这不起作用，任何人都可以帮助!!!!

尝试：

colum1：[query1]。[SumOfGoals] / [query1]。[SumOfApperances]


并在这个新查询中使用您的查询和总和！
< br $>
:)

嗨

我似乎无法让它工作，它改变了一些泉水


colum1：query1.SumOfGoals / query1.SumOfApperances


你能解释一下吗，请

< blockquote>那么你可以传入SQL模式并复制并粘贴到您的基于查询的SQL论坛吗？


这是对数据进行操作而不是聚合的方式数据！


如果你的数据是汇总的，那么使用Sum（[Field1]）/ sum（[Field2]）


当有数据时一个pb给出显示的错误或消息！


和sql看看pb是什么！


：）

I have 2 tables that hold similair information, i have a query running off then to total up the sum of a couple of colums, i want to run another query that will create a colum that holds the 2 of the first query colums divided by each other if that makes sense, I thought it was as simple as e.g.
colum1: query1.SumOfGoals / query1.SumOfApperances
but this doesn''t work, can anyone help!!!!

解决方案

Hi,

Try:
colum1: [query1].[SumOfGoals] / [query1].[SumOfApperances]

And use your query with sums in this new query!

:)

I have 2 tables that hold similair information, i have a query running off then to total up the sum of a couple of colums, i want to run another query that will create a colum that holds the 2 of the first query colums divided by each other if that makes sense, I thought it was as simple as e.g.
colum1: query1.SumOfGoals / query1.SumOfApperances
but this doesn''t work, can anyone help!!!!

Hi,

Try:
colum1: [query1].[SumOfGoals] / [query1].[SumOfApperances]

And use your query with sums in this new query!

:)

Hi
I cant seem to get it to work, it changes the springs some what too

colum1: query1.SumOfGoals/query1.SumOfApperances

can you explain a little further, please

So can you pass in SQL mode and do Copy and Paste into the forum your SQL on which is based your query?

This is the manner to do operations with data but not aggregate data!

If your data is aggregate so use Sum([Field1])/sum([Field2])

Pls when there is a pb give the error that is displayed or the message!

And the sql to see what is the pb!

:)

这篇关于查询中的计算 - 苦苦挣扎!!!!的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！