在访问报告中不隐藏任何数据字段 [英] Hide no data fields in access reports

问题描述

我是ms-access的新手，我需要一些关于报告的帮助。我为有14个领域的员工准备了工资单交易。我想隐藏一些没有数据的字段（只有零）。我想为整个报告编写一个代码而不是特定字段。如果某些数据不存在则应该出现。


有人可以帮我解决这个问题


vsts

Hi,
I am new to ms-access, i need some help on reports. I prepared payroll transactions for staff in which there are 14 fields. I want to hide some fields which has no data (only zeros). I want to write a code to whole report not for a particular field. If should appear when some data is there not zeros.

can somebody help me out in this plzzzzzzzzzz

vsts

推荐答案

我是ms-access的新手，我需要一些报告方面的帮助。我为有14个领域的员工准备了工资单交易。我想隐藏一些没有数据的字段（只有零）。我想为整个报告编写一个代码而不是特定字段。如果某些数据不存在则应该出现。


有人可以帮我解决这个问题吗


vsts

Hi,
I am new to ms-access, i need some help on reports. I prepared payroll transactions for staff in which there are 14 fields. I want to hide some fields which has no data (only zeros). I want to write a code to whole report not for a particular field. If should appear when some data is there not zeros.

can somebody help me out in this plzzzzzzzzzz

vsts

您必须单独执行每个字段并将代码放在报告的格式化事件中。类似

You will have to do each field individually and put the code in the format event of the report. Something like

展开 | 选择 | Wrap | < span class =codeLinkonclick =LineNumbers（this）;>行号

感谢您的支持......实际上我有一个字段dearnesspay欠款 ;在我的数据库中。当我在您给出的代码中输入此字段名称时，它会在欠款上显示错误。现场的名字有什么问题..

请指导我

这个地方应该被下一个领域覆盖......


vsts

Thank you for your support... actually i have a field "dearnesspay arrears" in my database. when i enter this field name in the code given by you it is showing error on "arrears". is there any problem in field''s name..
please guide me
and the place should be covered by the next field...

vsts

谢谢......它的工作和空间没有被下一个字段覆盖。我还需要一个PF的帮助计算仅适用于部分员工，但根据我的查询计算所有员工..你能帮助我吗？

Thank you .. its working and the space is not covering by the next field. I need one more help calculation of PF is applicable for only some of the employees but as per my query its calculating for all the employees.. can you help me in this too..

这篇关于在访问报告中不隐藏任何数据字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！