在访问中搜索查询 [英] Search query in access
问题描述
嗨
我正在创建一个专为出租店设计的Access数据库，我有下表：
Field 1 ：帐户ID
字段2：电影ID 1
字段3：电影ID 2
字段4：电影ID 3
字段5：电影ID 4
字段6：电影ID 5
当然，帐户ID是指客户帐户，电影ID 1 -5是客户排名前五的最受欢迎的电影。这将有助于工作人员确定与特定客户的电影选择的可能趋势。
当我尝试在QBE窗格中创建查询时，我想知道用户是否可以输入一次FILM ID，但字段2-6都是检查以找到正确的结果。目前如果我想搜索字段12-6我需要单独搜索每个字段并输入五次电影ID。
你的感谢
Hi
An Access database I am creating which is designed for a rental shop, I have the following table :
Field 1 : Account ID
Field 2: FILM ID 1
Field 3: FILM ID 2
Field 4: FILM ID 3
Field 5: FILM ID 4
Field 6: FILM ID 5
The account id of course refers to the customers account, and FILM ID 1-5 is the customers top five most rented films. This would help the staff determine possible trends in film choices with a particular customer.
When I attempt to create a query in the QBE pane, I would like to know if it is possible for the user to type in a FILM ID once but fields 2-6 are all checked in order to find the correct result. Currently If i want to search fields 12-6 I need to search each field individually and type in the FILM ID five times.
Yours gratefully
推荐答案
嗨
我正在创建的Access数据库，专为租赁商店设计，我有以下内容表：
字段1：帐户ID
字段2：电影ID 1
字段3：电影ID 2
字段4：电影ID 3
字段5：电影ID 4
字段6：电影ID 5
当然，帐户ID是指客户帐户，而FILM ID 1-5是客户最常租借的五大电影。这将有助于工作人员确定与特定客户的电影选择的可能趋势。
当我尝试在QBE窗格中创建查询时，我想知道用户是否可以输入一次FILM ID，但字段2-6都是检查以找到正确的结果。目前如果我想搜索字段12-6我需要单独搜索每个字段并输入五次电影ID。
你的感谢
Hi
An Access database I am creating which is designed for a rental shop, I have the following table :
Field 1 : Account ID
Field 2: FILM ID 1
Field 3: FILM ID 2
Field 4: FILM ID 3
Field 5: FILM ID 4
Field 6: FILM ID 5
The account id of course refers to the customers account, and FILM ID 1-5 is the customers top five most rented films. This would help the staff determine possible trends in film choices with a particular customer.
When I attempt to create a query in the QBE pane, I would like to know if it is possible for the user to type in a FILM ID once but fields 2-6 are all checked in order to find the correct result. Currently If i want to search fields 12-6 I need to search each field individually and type in the FILM ID five times.
Yours gratefully
您当前的表结构肯定不利于提取您正在描述的数据。理想情况下，您应该通过AccountID在1到MANY关系中链接客户表（tblCustomers）和租赁表（tblRentals）。所有租赁现在都将存在于子表中，并且请求有关租用电影的统计信息将是轻而易举的。
Your current Table structure is definately not conducive to extracting data such as you are describing. Ideally, you should have a Customers Table (tblCustomers) and a Rental Table (tblRentals) linked in a 1 to MANY Relationship via an AccountID. All Rentals would now reside in Child Table and requested statistics on Rented Films would be a breeze.
您好
感谢您的帖子。我可以重新排列表结构，但是我真的想知道是否可以使用一个条目搜索多个字段？这可能吗？
谢谢
Hi
Thank you for your post. I could rearrange the table structure, however I really would like to know if it would be possible to search multiple fields using one entry however ? is this possible ?
thank you
嗨
我正在创建的Access数据库是专为出租商店设计的，我有下表：
字段1：帐户ID
字段2：电影ID 1
字段3：电影ID 2
字段4：电影ID 3
字段5：电影ID 4
字段6：电影ID 5
当然，帐户ID是指客户帐户，电影ID 1-5是客户最常租用的五大电影。这将有助于工作人员确定与特定客户的电影选择的可能趋势。
当我尝试在QBE窗格中创建查询时，我想知道用户是否可以输入一次FILM ID，但字段2-6都是检查以找到正确的结果。目前如果我想搜索字段12-6我需要单独搜索每个字段并输入五次电影ID。
你的感谢
Hi
An Access database I am creating which is designed for a rental shop, I have the following table :
Field 1 : Account ID
Field 2: FILM ID 1
Field 3: FILM ID 2
Field 4: FILM ID 3
Field 5: FILM ID 4
Field 6: FILM ID 5
The account id of course refers to the customers account, and FILM ID 1-5 is the customers top five most rented films. This would help the staff determine possible trends in film choices with a particular customer.
When I attempt to create a query in the QBE pane, I would like to know if it is possible for the user to type in a FILM ID once but fields 2-6 are all checked in order to find the correct result. Currently If i want to search fields 12-6 I need to search each field individually and type in the FILM ID five times.
Yours gratefully
你能举个例子吗。
我很害怕我很难理解你到底发生了什么。
你的最后一句话特别混淆了我对12-6字段的引用？
Could you perhaps post an example.
I''m afraid I''m struggling to understand what you''re after exactly.
Your last sentence confuses me particularly with a reference to fields 12-6?
这篇关于在访问中搜索查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
