基于其他领域的独特价值观

在表格的下半部分是一个打开报告的按钮。 在查询条件中我使用Like [forms]！[frm_report]。[combo_type ]& * 这对于组合框很有用，我会得到超级报告。 但是，现在我必须打印两份报告（类型新和类型扩展名 我想要的是当我从组合框中选择new时，其结果将是是所有记录，其中类型是新或扩展 这是否更好地解释了我的问题？ 我真的希望你能帮助我！ 提前致谢， pierreHello NeoPa,I will try to explain a little further;I have a form for generating a report.The form is based on a query with all records in it.On the form there are 4 combo boxes from which the user can choose certain data (like [tr_type] new, renewal, extension, DIP)On the lower part of the form is a button to open the report.In the query criteria i use a Like[forms]![frm_report].[combo_type] & "*"This works great for the comboboxes and i get super reports.However, now i have to print two reports (a type "new" and a type "extension"What i want is that when i choose "new" from the combobox with the type in it, the result will be all records where type is either "new" or "extension"Does this explain my problem better?I truly hope you can help me!Thanks in advance,pierre这是一个更好的解释皮埃尔，但它不是给我我要求的详细信息。你有问题吗？ 听起来你只想从列表中排除记录{2，Extension}。看起来非常简单。 当你来设计和调用报告时，我建议你删除过滤中的任何引用电子表格。相反，在VBA中构建它并仅在它打开时将其应用于报表。这有意义吗？ 表单上的示例过滤提供了有关如何管理这些内容的提示。本文侧重于过滤表单，但表单和报表使用相同的方法。It is a better explanation Pierre, but it doesn''t give me the details I requested. Are you having a problem with that?It sounds like you simply want to exclude the record {2,"Extension"} from your list. This seems very straightforward.When you come to designing and invoking the report, I would suggest getting rid of any references in your filtering to the form. Instead, build this in the VBA and apply it to the report only when it''s opened. Does this make sense? Example Filtering on a Form gives tips on how that can be managed. The article focuses on filtering forms, but the same approach is used for Forms and Reports. 这篇关于基于其他领域的独特价值观的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！