Group by Sku,合并数据 - 字符串聚合(Group By Sku, Merge Data - String Aggregation)
我想不出在访问中解决这个问题的最佳方法。 有一点需要注意。 大概还有15个其他领域,但它们都应该是重复数据,就像sku一样。
Original Sku | Category Apple | Fruit Apple | Consumable Need Sku | Category Apple | Fruit,Consumable从下面评论的洞察后,我能够做到这一点
SELECT [rg test].PROD_CODE, DConcat("PRODREPGDE","[rg test]","[PROD_CODE] = '" & [PROD_CODE] & "'") AS [Reporting Group] FROM [rg test] GROUP BY [rg test].prod_code;I can't think of the best way to tackle this in access. One thing to note. There are probably 15 other fields as well but they should all be duplicate data, just like sku.
Original Sku | Category Apple | Fruit Apple | Consumable Need Sku | Category Apple | Fruit,ConsumableAfter insight from comments below I was able to make this work
SELECT [rg test].PROD_CODE, DConcat("PRODREPGDE","[rg test]","[PROD_CODE] = '" & [PROD_CODE] & "'") AS [Reporting Group] FROM [rg test] GROUP BY [rg test].prod_code;最满意答案
从下面评论的洞察后,我能够做到这一点
SELECT [rg test].PROD_CODE, DConcat("PRODREPGDE","[rg test]","[PROD_CODE] = '" & [PROD_CODE] & "'") AS [Reporting Group] FROM [rg test] GROUP BY [rg test].prod_code;After insight from comments below I was able to make this work
SELECT [rg test].PROD_CODE, DConcat("PRODREPGDE","[rg test]","[PROD_CODE] = '" & [PROD_CODE] & "'") AS [Reporting Group] FROM [rg test] GROUP BY [rg test].prod_code;更多推荐
发布评论