函数IsSelectedVar和Null值 [英] Function IsSelectedVar and Null value

问题描述

你好

我需要一些函数IsSelectedVar和有空值的字段的帮助。我有一个有4个多选列表框的表单;它们用于过滤报告的记录。 4个字段是站点位置，主要功能，辅助功能，第三功能。辅助功能和Tertiary_function在字段中并不总是具有值。当我尝试运行报表或基础查询时，如果该字段没有值，则记录将不会显示。例如，如果我选择所有健身房，对于一组位置，我将获得与健身房相关的所有项目。储藏室等，但健身房本身。任何人都可以帮忙吗？

谢谢

Hello
I need some help with the Function IsSelectedVar and fields that have null value. I have a form that has 4 multi select list boxes; they are used to filter records for reports. The 4 fields are Site location, Primary function, secondary function, Tertiary_function,. The secondary function and Tertiary_function will not always have a value in the field. When I try to run the report or the underlying query, if the field has no value the records will not show up. Example, if I select all of the Gyms, for a group of locations, I will get all items associated with the Gym I.e. storage rooms etc, but the gyms themselves. Can anyone help?
Thanks

推荐答案

您好，您如何设置报告的标准？

例如，在查询的SQL中设置查询的where子句，还是在vba中构建条件并将其传递给openreport命令的where语句参数？

Hi, how are you setting the where criteria for the report?
For example is the where clause of your query set within the SQL of your query or are you building the criteria in vba and passing it into the where statement parameter of the openreport command?

您好，您如何设置报告的where标准？

例如，在查询的SQL中设置查询的where子句，还是在vba中构建条件并将其传递给openreport命令的where语句参数？

Hi, how are you setting the where criteria for the report?
For example is the where clause of your query set within the SQL of your query or are you building the criteria in vba and passing it into the where statement parameter of the openreport command?

对不起，我发布这个原始帖子

Sorry I ment to post this orginal post

< span class =codeLinkonclick =Blur（this，this.parentNode.parentNode，getChildren（this），true）;>展开 | 选择 | Wrap | 行号

我认为解决方案是从查询中删除where子句并根据所有返回值创建报告。然后在打开报告时，在open report命令中指定where语句。


这需要一些VBA编码。其背后的想法就是按一下按钮，例如，将构建一个条件字符串，该条件字符串接收表单上的所有选定参数，并将其传递给openreport命令，并根据条件字符串进行过滤。

I think a solution would be to remove the where clause form your query a create a report based on all returned values. Then when opening the report specify the where statement in the open report command.

This will require some VBA coding. The idea behind it is on say a button click for example that a criteria string will be built that takes in all selected parameters on a form that passes them into the openreport command and it filters based on the criteria string.

这篇关于函数IsSelectedVar和Null值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！