在查询中使用相同的术语搜索多个字段 [英] Searching across many fields with the same term in a query

问题描述

是否可以在多个字段中搜索相同的搜索字词字段？


我基本上需要它来进行此类搜索：


如果[ref]或[name]或[address]包含[*搜索词*]


这也需要与其他一些过滤器一起使用，所以它会必须成为查询的一部分我想..


谢谢

Is it possible to search across many fields for the same search term field?

I basically need it to do this kind of search:

If [ref] or [name] or [address] contains [*search term*]

This needs to be incorporated along with a few other filters too, so it would have to be part of a query i guess..

Thanks

推荐答案

是否可以在同一搜索词字段中搜索多个字段？


我基本上需要它来进行这种搜索：


如果[ref]或[name]或[address]包含[*搜索词*]


这也需要与其他一些过滤器一起使用，所以它会必须成为查询的一部分我猜...


谢谢

Is it possible to search across many fields for the same search term field?

I basically need it to do this kind of search:

If [ref] or [name] or [address] contains [*search term*]

This needs to be incorporated along with a few other filters too, so it would have to be part of a query i guess..

Thanks

您是想在设计视图中创建的查询中执行此操作，还是在谈论在VBA中执行此操作代码（例如，在表单上的按钮的单击事件中）？

*搜索项*的来源是什么？它是用户在表单上的字段中输入的值，还是在用户运行查询时在运行时提示的？还有什么吗？


让我知道你想要什么，我应该能给你一些如何做的例子。


此致，

Zwoker。

Hi,

Are you wanting to do this in a Query created in Design View, or are you talking about doing it in VBA code (in the click event of a button on a form, for example)?

And what would the source of the *search item* be? Is it a user entered value in a field on a form, or prompted at runtime when the user runs a query? Something else?

Let me know what you are wanting and I should be able to give you some examples of how to do it.

Regards,
Zwoker.

Are你想在设计视图中创建的查询中执行此操作，还是在谈论在VBA代码中执行此操作（例如，在窗体上按钮的单击事件中）？


*搜索项*的来源是什么？它是用户在表单上的字段中输入的值，还是在用户运行查询时在运行时提示的？还有什么吗？


让我知道你想要什么，我应该能给你一些如何做的例子。


此致，

Zwoker。

Hi,

Are you wanting to do this in a Query created in Design View, or are you talking about doing it in VBA code (in the click event of a button on a form, for example)?

And what would the source of the *search item* be? Is it a user entered value in a field on a form, or prompted at runtime when the user runs a query? Something else?

Let me know what you are wanting and I should be able to give you some examples of how to do it.

Regards,
Zwoker.

谢谢。


我认为这需要在查询中完成，以便我可以更轻松地过滤我的记录。 br />

目前我的查询过滤掉标记为已删除的记录，然后过滤记录类型（投诉，事件和赞美）


这将是如果我也可以添加一个搜索框，那么我就可以使用，所以我可以搜索标记为投诉的所有记录。其中包含互联网一词在任何领域。


表单有大约6个字段，我想检查是否存在关键字，但如果查询查询中的每个字段都不会产生太大影响。


感谢您的帮助

thanks.

I think this needs to be done in a query so that I can filter my records easier.

currently my query filters out records flagged as deleted and then filters for the type of record (complaint, incident and compliment)

It would be useful if I could have a search box added on to this as well, so I could, for example, search for all records flagged as "complaints" that contained the word "internet" in any of the fields.

The form has about 6 fields that I would like to check for the presence of the keyword, but it wont have much impact if every field within the query is checked for the keyword.

Thanks for your help

任何帮助？


似乎是大多数数据库的基本功能。能够做找到在许多领域...

Any help?

Seems like a basic function for most databases. being able to do a "find" across many fields...

这篇关于在查询中使用相同的术语搜索多个字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！