本文介绍了文本框中的#error修复的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述




我有一个db给我一个问题。我有一个表单,其中包含一个子表单,显示从组合框和选项按钮中过滤的数据。一切正常。


我现在在主表格底部的文本框显示某些数据(以子表格计算记录,平均出勤率,平均得分和最高支出费用)。这些都链接到子表单页脚中的文本框。


我已经计算了计数记录和平均出勤率,但剩下的两个框正在困扰我。得分的平均分数有效,但是当没有任何东西可以平均显示#error我想改变显示0.我已经尝试了Nz和Null值的所有版本都无济于事。


文本框中的当前代码如下:

Hi,

I have a db that is giving me a problem. I have a form which contains a sub-form that displays data that is filtered from combo boxes and option buttons. This all works fine.

I now text boxes at the bottom of my main form which display certain data (count records in sub form, Average attendance, Average mark scored, and highest expense paid). These are all linked to text boxes in the footer of the sub form.

I have got working the count records and average attendance however the remaining two boxes are stumping me. The average mark scored works however when there is nothing for it to avg it displays #error which I want to change to display 0. I have tried Nz and all versions on Null values to no avail.

The current code in the text box is as follows:

展开 | 选择 | Wrap | 行号

推荐答案

展开 | 选择 | Wrap | 行号




这篇关于文本框中的#error修复的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

05-28 06:46
查看更多