宏生成器条件 [英] Macro Builder Where Condition

问题描述

我在报告中并创建了一个按钮来将我带到表单中，我需要将报表中的自动编号与表单中的相同记录进行匹配。我知道如何为文本字段编写代码（例如：=" [Text Field] ='"& [Text Field]&
"'"），但我不知道如何对于数字字段，例如自动编号;我的自动编号字段被命名为"ID"，那么你如何为这个数字字段编写字符串，或者换句话说，它将如何与文本字段不同？

解决方案

省略单引号：

" [ID] =" &安培; [ID]

I'm in a report and have created a button to take me to a form and I need to match the autonumber in the report with the same record in the form. I know how to write that code for text fields (example: ="[Text Field] = '" & [Text Field] & "'"), but I don't know how for numeric fields such as an autonumber; my autonumber field is named "ID", so how would you write the string for this numeric field, or in other words how would it be different than the text field?

解决方案

Omit the single quotes:

"[ID]=" & [ID]

这篇关于宏生成器条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！