MS Access 交叉表查询参数

发布于 2024-07-27 03:41:39 字数 237 浏览 5 评论 0原文

有没有办法像选择查询一样在查询中引用表单的组合/文本框？

我通常在选择查询的条件中使用类似的东西：

like forms!frmMain.qTitleofSomething&*   (access adds the brackets for me)

但这在交叉表查询中不起作用？我刚刚发现。有没有一种方法可以在不设置多个交叉表的情况下完成同类参数控制？

原文

Is there a way to reference a form's combo/text box within the query like a select query?

I usually use something like this in a select query's criteria:

like forms!frmMain.qTitleofSomething&*   (access adds the brackets for me)

but this does not work in a crosstab query?? which I just found out. is there a way to accomplish the same kind of parameter control without setting up multiple crosstabs?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

許願樹丅啲祈禱 2024-08-03 03:41:39

如果您希望引用表单，则需要向查询添加参数。您可以通过在查询设计窗口中右键单击或在 SQL 视图中键入参数来完成此操作。您最终应该得到如下内容：

PARAMETERS [Forms]![frmA]![Field1] Short;
TRANSFORM Count(tblA.ID) AS CountOfID
SELECT tblA.Field2, Count(tblA.ID) AS [Total Of ID]
FROM tblA
WHERE tblA.Field1=[Forms]![frmA]![Field1]
GROUP BY tblA.Field2
PIVOT tblA.Field1;

Short 指的是字段的数据类型。这些类型包含在下拉列表中，可通过在查询设计窗口中右键单击并选择参数来访问。

You need to add a parameter to the query if you wish to reference a form You can do this by right-clicking in the query design window or by typing it into the SQL view. You should end up with something on the lines of:

PARAMETERS [Forms]![frmA]![Field1] Short;
TRANSFORM Count(tblA.ID) AS CountOfID
SELECT tblA.Field2, Count(tblA.ID) AS [Total Of ID]
FROM tblA
WHERE tblA.Field1=[Forms]![frmA]![Field1]
GROUP BY tblA.Field2
PIVOT tblA.Field1;

Short refers to the data type of the field. The types are included in a drop down list available from right-clicking in the query design window and selecting Parameters.

回复收藏 0 原文

~没有更多了~