获取strwhere表的总和 - Filter [英] Get the sum of strwhere table - Filter

问题描述

我有以下代码，它显示了一个表的数据过滤器，它工作正常。我的问题是，当我在表单中运行查询时，我无法根据过滤数据得到总数。


我的问题是我怎么能把文字标签显示给我总过滤数据？我需要标签的代码？

I have the following codes which is show me a filter of data from a table, it works fine. My problem is when i run the query in the form i can''t get the total based on the filtering data.

MY question is how i can put a text label shows me the total of the filtering data? i need the code for the label?

展开 | 选择 | Wrap | 行号

推荐答案

请在使用代号时使用发布代码。


总计是什么？过滤记录的总数？这个显示在表格底部的导航栏中。


或者你的意思是未经过滤的记录总数？你可以使用DCount功能。


或者你的意思是其他一些你没有定义的总数？你必须在任何帮助之前解释一下。

Please use code tags when posting code.

Total of what? the total number of filtered records? That''s shown in the navigation bar at the bottom of the form.

Or do you mean total number of unfiltered records? That you can get using the DCount function.

Or do you mean some other total of which you have not defined? That you have to explain before any help can be offerred.

好吧，我有一张表有以下内容：

否，AcctGroupName，AccTypeName，Amounts


我根据AcctGroupName和AccTypeName为这个表做了过滤器，（这是一个继续表）它完美无缺


我的问题是我需要在表单页脚中添加一个textlabel，根据过滤后的数据显示总金额。


对此我很抱歉，但我是vba中的新人

okay, I have a table which has the following :
No, AcctGroupName, AccTypeName, Amounts

I made the filter for this table based on AcctGroupName and AccTypeName, (it’s a continues table) it works perfect

My question is I need to add a textlabel in form footer to show me the total amount based on the filtered data.

Sorry about that but I am new in vba

我需要答案

这篇关于获取strwhere表的总和 - Filter的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！