需要了解Where条件标准

人气:280 发布:2022-09-22 标签: accessdev

问题描述

你能帮助我理解并举出"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.

718