datewindow的group窗口对象问题(急)
我的sql语句如下:
SELECT distinct [advdetail.ProName], [advdetail.Vector], Count([advdetail.Vector]) AS 版幅频次,
[advdetail.Color], Count([advdetail.Color]) AS 版色频次
FROM advdetail
WHERE (advdetail.AdvDate Between :Start_y_m And :End_y_m)
GROUP BY [advdetail.ProName], [advdetail.Vector], [advdetail.Color]
在设计统计时,我想只对[advdetail.ProName]分组统计,但实际上得到的结果是先
[advdetail.ProName],然后[advdetail.Vector],最后[advdetail.Color],如
sum( 版幅频次 for group 1 )统计,出现了[advdetail.ProName]的重复项,因为同一个[advdetail.ProName]有不同的[advdetail.Vector]。请问如何解决