特定字段可以引用列出的多个表 [英] Specific field could refer to more than one table listed

问题描述

ACCESS 2010：我在ACCESS 2010中有一个报告，当我尝试运行它时说：特定字段[合同数据] .TERM"可以引用SQL语句的FROM子句中列出的多个表。它运行得很好，直到我尝试添加一个新的查询，该查询总计了所教授的单位数，并为报表查询添加了求和查询。他们都使用相同的表格。不知道该怎么做。

ACCESS 2010: I have a report in ACCESS 2010 that when I try to run it says: "The specific field"[Contract Data].TERM" could refer to more than one table listed in the FROM clause of your SQL statement." It ran perfectly until I tried to add a new query that totaled the number of units taught and added a summing query to the report query. They all use the same tables. Not sure what to do.

推荐答案

请列出你的SQL语句，我们可以尝试为你调试。否则，我们无需继续。

Please list your SQL statement and we can try to debug for you. Otherwise, we have nothing to go on.

展开 | 选择 | Wrap | 行号

还有一个子报表查询：

There is also a sub report query:

展开 | 选择 | Wrap | 行号

这篇关于特定字段可以引用列出的多个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！