问题描述
你能帮助我理解并举出"Where Condition"的例子吗?尝试匹配字段类型时的标准,例如尝试将表单中的字段与报表中的字段匹配(因此我可以打印或通过电子邮件发送相同的记录)。如何在"where condition"中的宏构建器中编写字符串我的部件号字段中的内容与我的报告中的相同字段匹配?您能给我一些匹配两个数字字段和另一个匹配两个文本字段的示例。谢谢。
Kevin Landress
Could you help me understand and give examples of "Where Condition" criteria when trying to match the field type, say trying to match a field in my form with a field in a report (so I can print or email the same record). How do I write the string in the macro builder in the "where condition" matching the contents in my part number field with the same field in my report? Would you give me examples of matching two number fields and another matching two text fields. Thank you.
Kevin Landress
推荐答案
这是我在网上搜索的第一个"访问标准数据类型"
This was the first hit when I searched online for "access criteria data type"
https://support.office.com/en-us/article/Examples-of-query-criteria-3197228C-8684-4552-AC03- ABA746FB29D8
https://support.office.com/en-us/article/Examples-of-query-criteria-3197228C-8684-4552-AC03-ABA746FB29D8
我认为它会为您提供所需的所有答案。
I think it will give you all the answers you're looking for.