记录计数和“无效使用空”的问题 [英] Problem with record counts and "Invalid Use of Null"

问题描述

我有一个简单的问题，但我似乎无法找到答案。



我有这个代码来计算通过的记录数一组过程：


它计算通过输入，验证，错误的记录数量


这是获取数字的代码：

I have a simple question, but I can''t seem to find the answer.


I have this code to count the number of records that pass through a set of processes:

It counts how many records go through INPUT, VALIDATED, ERRORS

This is the code to get the numbers:

展开 | 选择 | Wrap | 行号

推荐答案

另一件事，我必须解决这个问题的一个想法是更改追加的查询查询更新查询，然后只更新ta中的字段通过匹配描述， - 那样就会有一条带有Validated的记录。除非更新，否则表中的值为0。但我似乎无法根据标准获得更新查询。


再次感谢

One other thing, one idea I had to address this is change the queries for Append Queries to Update queries, and then simply update the fields in the table by Matching the descriptions, - that way there would already be a record with "Validated" and a value of 0 in the table, unless it got updated. But I can''t seem to get an update query to count based on criteria.

Thanks again

我有一个简单的问题，但我似乎无法找到答案。



我有这个代码来计算那些记录的数量通过一系列过程：


它计算通过INPUT，有效，错误的记录数量


这是获取数字：

I have a simple question, but I can''t seem to find the answer.


I have this code to count the number of records that pass through a set of processes:

It counts how many records go through INPUT, VALIDATED, ERRORS

This is the code to get the numbers:

展开 | 选择 | Wrap | 行号

试试这个：

Try this:

展开 | 选择 | Wrap | 行号

这篇关于记录计数和“无效使用空”的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！