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

问题描述

我有一个表(客户),其中包含一个包含"来源"信息的字段。 我试图在用户定义的时间范围内计算该字段的出现次数。 我已整理了以下内容:



这给了我们按来源分组的整个表格;计算出现次数;合并价格....
$
SELECT Customers.Source,Count(Customers.CustDate)AS CountCustDate,Sum(Customers.ContractPrice)AS SumContractPrice

FROM Customers

GROUP BY Customers.Source

ORDER BY Customers.Source;



我把它放在一起以便允许在用户定义的日期范围内抓取信息:

SELECT DCount(" Customers.Source" =" Call / Walk In"," Customers"," Source Between#"& [输入开始日期]&"#和#"& [输入结束日期]&"#")AS CallWalkIn;



.. 。然而,当它应该是"5"时,这将返回"0"。
b
$
...这也将用于计算其他几个值。



正如你所看到的,我也想要总结'contractprice'值。

I have a table (Customers) with a field that holds 'Source' information.  I am trying to count the number of occurances of this field within a user defined time frame.  I have put together the following:

This gives us the whole table grouped by Source; Counting the occurances; and summing the contract price....
SELECT Customers.Source, Count(Customers.CustDate) AS CountCustDate, Sum(Customers.ContractPrice) AS SumContractPrice
FROM Customers
GROUP BY Customers.Source
ORDER BY Customers.Source;

I have put this together to allow for grabbing the information within a user defined date range:
SELECT DCount("Customers.Source" = "Call/Walk In","Customers","Source Between #" & [Enter Start Date] & "# And #" & [Enter End Date] & "#") AS CallWalkIn;

...however, this returns a "0", when it should be "5".

...this will also be used to count for several other values.

As you can see, I will also be wanting to sum the 'contractprice' values.

我也试过这个,但它没有用....

I tried this too, but it did not work....

我知道我很接近,但等于捕获的字段值的等式让我陷入困境......想法?

I know I am close, but the equation to equal the captured field values is keeping me at bay....thoughts?

谢谢你,Mayhem65

Thank you, Mayhem65

推荐答案

如果您打算在表单上显示此内容,我建议您避免使用参数查询。

If you're planning to display this on a form, I would probably suggest to avoid using a parameter query.

因此,如果您的第一个查询返回表中的所有记录,那么你的DCount()或DSum()表达式可以计算出给定日期范围内的总数而没有任何问题。

So, if your first query returns all the records from the table, then your DCount() or DSum() expression can calculated the totals within a given date range without any problems.

例如,要计算原始查询中的Source,你可以尝试例如:

For example, to count the Source from your original query, you could try something like:

= DCount(" *"," QueryName"," Source ='Call / Walk In'AND CustDate between& [StartDate]& amp; ;"#和#"& [EndDate]&"#")

=DCount("*", "QueryName", "Source='Call/Walk In' AND CustDate Between #" & [StartDate] & "# And #" & [EndDate] & "#")

希望有帮助......

Hope it helps...


这篇关于计算源信息的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

11-01 05:59