我有一个从包含计算字段的查询派生的子表单 . 它不会在表单视图中显示 . 我设置了主字段和子字段链接,我的'允许添加'属性设置为是 . 我发现的原因之一是“表单基于没有记录的表格” . 情况如此 . 它当然是一对多的关系,子表格是多方面的表格 .
这是查询:
SELECT [Management Accounting table].Date_To_Budgets,
[Management Accounting table].Date_Returned_To_SCM,
[Management Accounting table].Date_To_Assets,
[Management Accounting table].Date_Returned_From_Assets,
[Management Accounting table].Select_Fund,
[Management Accounting table].Project,
[Management Accounting table].Select_SubProgramme,
[Management Accounting table].Cost_Centre,
[Management Accounting table].Item,
[Management Accounting table].Supplier,
[Management Accounting table].Amount,
Sum([Management Accounting table].Amount) AS [Total Amount],
SLD_Number
FROM [Management Accounting table]
GROUP BY [Management Accounting table].Date_To_Budgets,
[Management Accounting table].Date_Returned_To_SCM,
[Management Accounting table].Date_To_Assets,
[Management Accounting table].Date_Returned_From_Assets,
[Management Accounting table].Select_Fund,
[Management Accounting table].Project,
[Management Accounting table].Select_SubProgramme,
[Management Accounting table].Cost_Centre,
[Management Accounting table].Item,
[Management Accounting table].Supplier,
[Management Accounting table].Amount,
SLD_Number;