如何将多行文本值合并到访问查询中的单个单元格中

Question

你能帮我做这个吗：请看下面的图片

Answer 1

既然你提到你现在有ConcatRelated() 函数，您可以使用此查询，它只是Discount对所有行的列求和，并用于ConcatRelated连接Reason所有行的值：

SELECT Sum(Discount) AS Total_Discounts
     , ConcatRelated("Reason", "Table1") AS The_Reasons
FROM Table1;

如果您希望查询Table2从第二张屏幕截图创建表，只需添加一个INTO子句：

SELECT Sum(Discount) AS Total_Discounts
     , ConcatRelated("Reason","Table1") AS The_Reasons
INTO Table2
FROM Table1;