访问查询帮助 [英] Access Query Help

问题描述

大家好，

我有3个包含相同字段但不同时期的表。现在我想进行查询以查找3个表的结果。所有3个表都包含VenueId，Categary，atotal等。查询结果包括VenueId，Categary，atotal（来自table1），atotal（来自table2），atotal（来自table3），all of all 3 atotal，Min值of the 3个表和另一个公式如（total-（min * 3）/ 3）。行业领域应按订单排序。

Hi All,
I have 3 tables that contains same fields but for different periods. Now i want to make a query to find the result from 3 tables. All the 3 tables contains VenueId, Categary, atotal, etc., The query result includes VenueId, Categary, atotal(from table1), atotal(from table2), atotal(from table3), Sum of all 3 atotal, Min value of the 3 tables and another formula like(total-(min*3)/3). The industry field should sort by assending order.

推荐答案

展开 | 选择 | Wrap | 行号

来自这个描述，这不是UNION的工作吗？

From the description, wouldn''t this be a job for UNION?

这是可能的，我考虑过这个选项，但考虑到观众，我决定避开它。

如果你是问题我至少会提到它。

考虑到UNIONs造成的一些影响（使Access忘记了一些关于源的重要信息我倾向于避开自己，除非它是唯一合理的方式。

It''s possible, I considered that option, but considering the audience I decided to steer clear.
Had you been the questionner I would have mentioned it at least.
Bearing in mind some of the effects caused by UNIONs (makes Access forget some of the important info about the source tables) I tend to steer clear myself except where it''s the only sensible way.

这篇关于访问查询帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！