问题描述
我不确定我是否正确地提出了我的问题。但我想要做的是运行两个相关表格的报告如下：
第一个表名为Category - 它有一个名为Category的字段，也是主键。表中列出了18种类别。
第二个表称为CaseManagement，没有主键，还有多个字段，包括从相关类别表中获取的类别。
他们与从Category到CaseManagement的一对多链接有关。
在我的报告中，我想列出所有类别表中的类别来自CaseManagement表中每个类别的案例数。
我的问题是，如果一个classesoy在CaseManagement表中没有任何相关数据，那么该类别不会列在我的报告中。我希望报告包含Cattegory表中的每个类别，如果它在CaseManagement表中没有任何相关数据，则显示0。
感谢您的帮助
Dan
I am not sure if I worded my question correctly. But what I want to do is run a report from two related tables as follows:
The first table is called Category - it has one field, called Category, that is also the primary key. There are 18 categries listed in the table.
The second table is called CaseManagement, with no primary key, and multiple fields including Category which is taken from the related Category table.
They are related with a one to many link from Category to CaseManagement.
In my report I want to list all the categories from the Category table followed by the number of cases in each category from the CaseManagement table.
My problem is that if a categoy does not have any related data in the CaseManagement table, the category is not listed in my report. I want the report to include every category from the Cattegory table and show a 0 for it if it does not have any related data in the CaseManagement table.
Thanks for any help
Dan
推荐答案
谢谢您的回复，但我在哪里放置此代码？请原谅我的无知。
感谢您的帮助。
Dan
Thankyou for your response but where do I place this code? Please excuse my ignorance.
Thank you for your help.
Dan
这篇关于如何显示没有匹配值的记录？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！