同时过滤多个表 [英] filtering multiple tables simultaneously

问题描述

嗨我想知道是否可以同时过滤多个表格。过滤器将自动应用即。在查询中。


但是我想在运行时只显示一个列表。因此，不是一个多重过滤器，而是一个表上的过滤器，其中所有数据都是临时放置的当过滤器运行时。每当数据库打开时，可能会通过使用和自动执行宏自动运行此过滤器。


每张桌子都有完全相同的场地。并且要过滤的领域是（完成日期）。它将通过过滤在完成的日期中没有数据的记录来过滤多个表中一次尚未完成的记录。感谢您提前的任何帮助。

我使用访问07

i对vb并不是非常熟悉并且只使用它来创建级联更新组合，但我应该没问题提供说明是明确的。

hi i was wondering if it is possible to filter multiple numbers of tables at the same time. the filter would be automatically applied ie. as in a query.

However i want only one list to appear when it is run.therefore not a exactly a multiple filter but a filter on one table where all the data is temporarily put when the filter is run. this filter would auto matically run whenever the databased is open presumably by using and autoexecute macro.

Every table has exactly the same feilds. and the feild to be filtered is (date finished). it would filter for records which are in multiple tables for once which had not been finished , by filtering for records with no data in the feild date finished. Thanks for any help in advance.
I use access 07
i am not extremely familar with vb and have only ever used it to create cascade update combos, but i should be fine providing instructions are clear.

推荐答案

我犹豫不决，但为什么你有多个具有完全相同结构的表？


您是否已阅读并理解本教程中的信息？ 数据库规范化和表格结构


你的问题......你可以通过使用Union查询来完成类似的事情。但是，如果（我怀疑）你有设计问题，处理设计问题将大大简化查询你想要看到的内容的任务。


问候，

Scott

I hesitate to ask, but why do you have multiple tables with the exact same structure?

Have you read and understood the information in this tutorial? Database Normalisation and Table Structures

On to your question... You can accomplish something similar to this by using a Union query. However, if (as I suspect) you have a design issue, taking care of the design issue will greatly simplify the task of querying for what you want to see.

Regards,
Scott

我犹豫不决，但为什么你有多个具有完全相同结构的表？ />

您是否已阅读并理解本教程中的信息？ 数据库规范化和表格结构


你的问题......你可以通过使用Union查询来完成类似的事情。但是，如果（我怀疑）你有设计问题，处理设计问题将大大简化查询你想要看到的内容的任务。


问候，

Scott

I hesitate to ask, but why do you have multiple tables with the exact same structure?

Have you read and understood the information in this tutorial? Database Normalisation and Table Structures

On to your question... You can accomplish something similar to this by using a Union query. However, if (as I suspect) you have a design issue, taking care of the design issue will greatly simplify the task of querying for what you want to see.

Regards,
Scott

i有多个具有相同场地的桌子，但它们有轻微的差异关系，但所有都基于相同的场地。

感谢无论如何生病查询联合查询微软办公室谢谢

i have multiple tables with the same feilds but they have slight diff relation ships depending but all are based on the same feilds.
Thanks anyway ill look up union querys on microsft office thanks

i有多个表具有相同的领域，但他们有轻微的差异关系船只取决于但所有都是基于相同的领域。

感谢无论如何生病查询联合查询微软办公室谢谢

i have multiple tables with the same feilds but they have slight diff relation ships depending but all are based on the same feilds.
Thanks anyway ill look up union querys on microsft office thanks

Daniel，


我的回复并非打算送您到另一个网站！如果您对如何规范表格有疑问，请随时向他们询问！


我想你会发现，如果你规范化表格，你就不需要调查联合查询了。一个简单的选择查询将完成这项工作。


如果您想让我了解您的桌子结构，我可以尝试帮助您改变它们。如果是这样，请发布每个表的表名，字段名和数据类型，以及每个字段中包含的数据的简短示例...


问候，

Scott

Daniel,

My reply was not intended to send you to another site! If you have questions about how to normalize your tables, feel free to ask them!

I think you will find that if you normalize the tables, you will not need to investigate union queries. A simple select query will do the job.

If you wish to give me an idea of the structure of your tables, I can try to help you with how to change them. If so, please post the table name, field names and data types for each table, and a brief sample of the data contained in each field...

Regards,
Scott

这篇关于同时过滤多个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！