在报告中创建条件 [英] Creating conditions within a Report
问题描述
您好我是这个论坛的新手。我使用的是Microsoft Access 2003和Windows XP 2002版本。
我有2个问题：
1）是否总有大量的可视化基本编码在设计视图中创建报告？ （我问，因为我只熟悉C / C ++）
2）我正在尝试创建一个报告，显示输入的用户的未分配余额一个月。
已有类似的报告，其中包括捐赠公司，接收机构，日期（总是一天04/01/2007~04 / 01/2007），然后食物的手续费。 （面包店，乳制品，肉类......等等）
我在本报告中看到，未分配的余额是通过减去每个捐赠公司专栏中的食物总lbs来计算的。它对应的接收机构栏目。注意：相应的代理商仅在选择相应的选项框时才会显示在报表上。 [前。捐赠面包店（75）~mentor1面包店（25）~agent2面包店（50）〜未分配余额（0）]
但我想要的只是向捐赠者/代理商展示未分配余额并且不显示其他。
Hello I am new to this forum. I am using Microsoft Access 2003 and Windows XP 2002 ver.
I have 2 questions:
1) Is there always a substantial amount of visual basic coding to create a report in design view? (I ask because I am only familiar with "C/C++")
2) I am trying to create a report that will display the undistributed balances for a user entered month.
There is already a similar report made which includes donor company, receiving agency, date(always a single day 04/01/2007 ~ 04/01/2007), and then the poundage of food. (bakery, dairy, meat...etc.)
I see that in this report the undistributed balances are calculated by subtracting the total lbs of food in each donor company column by those in it corresponding receiving agency column. Note: corresponding agencies only appear on the report when the respective option box is selected. [ex. donor bakery (75) ~ agency1 bakery (25) ~ agency2 bakery(50) ~ undistributed balance (0)]
But what I want is to only show the donor/agencies with an undistributed balance and to not display the others.
推荐答案
如果您有查询作为报告的记录来源，最简单的方法是打开查询设计视图并在未分配余额列的条件行中输入> 0。保存查询并重新运行报告... voilla !!!
If you have a query as the record source for your report, the easiest thing to do is to open your query in design view and enter >0 in the criteria row of the undistributed balance column. Save query and rerun report...voilla!!!
如果您有查询作为报告的记录来源，那么最简单要做的是在设计视图中打开您的查询，并在未分配的余额列的条件行中输入> 0。保存查询并重新运行报告... voilla !!!
If you have a query as the record source for your report, the easiest thing to do is to open your query in design view and enter >0 in the criteria row of the undistributed balance column. Save query and rerun report...voilla!!!
记录值是一个表。我已经有了未分配的字段。我要问的是我如何做到这一点，如果未分配的余额为零（0），捐赠者/代理商根本不显示。
目的是为了大大缩短了在给定月份内查找所有未分配余额所需的时间，而不是每天检查。
The record value is a table. I already have the undistributed fields working. What I''m asking about is how I would make it so that the donor/agency was not shown at all if its undistributed balance was zero(0).
The purpose is to greatly shorten the time it takes to find all the undistributed balances in a given month instead of checking every single day.
记录值为一张桌子。我已经有了未分配的字段。我要问的是我如何做到这一点，如果未分配的余额为零（0），捐赠者/代理商根本不显示。
目的是为了大大缩短了在给定月份内查找所有未分配余额所需的时间，而不是每天检查一次。
The record value is a table. I already have the undistributed fields working. What I''m asking about is how I would make it so that the donor/agency was not shown at all if its undistributed balance was zero(0).
The purpose is to greatly shorten the time it takes to find all the undistributed balances in a given month instead of checking every single day.
这是排除0余额的另一种简单方法。使用用于打开报告的VBA命令中的where子句选项，如下所示：
Here is another easy way to exclude 0 balances. Use the where clause option in the VBA command that you used to open the report, as shown below:
这篇关于在报告中创建条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
