ACCESS统计不重复记录个数问题
我在ACEESS做了一个窗体,内含一个子窗体，子窗体的控件来源是一个没有筛选条件的查询，在窗体里用VBA生成子窗体筛选条件。 例：在窗体输入筛选条件后，子窗体筛选结果为： 客户 字段1 字段2 ....(子窗体页眉) A 1 2 B 0 1 C 2 1 A 1 0 共?个客户 4 4 ....(子
我在ACEESS做了一个窗体,内含一个子窗体，子窗体的控件来源是一个没有筛选条件的查询，在窗体里用VBA生成子窗体筛选条件。
例：在窗体输入筛选条件后，子窗体筛选结果为：
客户 字段1 字段2 ....(子窗体页眉)
A 1 2
B 0 1
C 2 1
A 1 0
共?个客户 4 4 ....(子窗体页脚，作统计每一个字段数量的和)
因为客户字段会重复，我想在子窗体页脚新建一个文本框，统计每次窗体筛选结果后，客户不重复个数，并在文件框显示。试了很多种方法都不行，DISTINCT在文本框的控制来源不适用。在文本框的控件来源能实现吗?请教高手们有何办法?
问题补充：这条select语句我知道的,但只能用在查询里,不知道我想要的功能能否在子窗体实现呢?
最佳答案
对select语句，access数据库可以支持DISTINCT关键字，，但聚集函数就不支持了
可以这么写
select count(*) from (select distinct 要统计的字段名 from 表名)
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1386
52
How to convert deepseek pdf
Feb 19, 2025 pm 05:24 PM
DeepSeek cannot convert files directly to PDF. Depending on the file type, you can use different methods: Common documents (Word, Excel, PowerPoint): Use Microsoft Office, LibreOffice and other software to export as PDF. Image: Save as PDF using image viewer or image processing software. Web pages: Use the browser's "Print into PDF" function or the dedicated web page to PDF tool. Uncommon formats: Find the right converter and convert it to PDF. It is crucial to choose the right tools and develop a plan based on the actual situation.
How to solve the problem of third-party interface returning 403 in Node.js environment?
Mar 31, 2025 pm 11:27 PM
Solve the problem of third-party interface returning 403 in Node.js environment. When we use Node.js to call third-party interfaces, we sometimes encounter an error of 403 from the interface returning 403...
Laravel Redis connection sharing: Why does the select method affect other connections?
Apr 01, 2025 am 07:45 AM
The impact of sharing of Redis connections in Laravel framework and select methods When using Laravel framework and Redis, developers may encounter a problem: through configuration...
What are the benefits of multithreading in c#?
Apr 03, 2025 pm 02:51 PM
The advantage of multithreading is that it can improve performance and resource utilization, especially for processing large amounts of data or performing time-consuming operations. It allows multiple tasks to be performed simultaneously, improving efficiency. However, too many threads can lead to performance degradation, so you need to carefully select the number of threads based on the number of CPU cores and task characteristics. In addition, multi-threaded programming involves challenges such as deadlock and race conditions, which need to be solved using synchronization mechanisms, and requires solid knowledge of concurrent programming, weighing the pros and cons and using them with caution.
How to avoid third-party interfaces returning 403 errors in Node environment?
Apr 01, 2025 pm 02:03 PM
How to avoid the third-party interface returning 403 error in the Node environment. When calling the third-party website interface using Node.js, you sometimes encounter the problem of returning 403 error. �...
Unable to log in to mysql as root
Apr 08, 2025 pm 04:54 PM
The main reasons why you cannot log in to MySQL as root are permission problems, configuration file errors, password inconsistent, socket file problems, or firewall interception. The solution includes: check whether the bind-address parameter in the configuration file is configured correctly. Check whether the root user permissions have been modified or deleted and reset. Verify that the password is accurate, including case and special characters. Check socket file permission settings and paths. Check that the firewall blocks connections to the MySQL server.
How to use sql if statement
Apr 09, 2025 pm 06:12 PM
SQL IF statements are used to conditionally execute SQL statements, with the syntax as: IF (condition) THEN {statement} ELSE {statement} END IF;. The condition can be any valid SQL expression, and if the condition is true, execute the THEN clause; if the condition is false, execute the ELSE clause. IF statements can be nested, allowing for more complex conditional checks.
How to efficiently obtain component_verify_ticket in EasyWechat 5.5?
Apr 01, 2025 pm 12:42 PM
Get ComponentVerify in EasyWechat5.5...
