Ben wat rap geweest, hierbij dan:
TRANSFORM Sum(t_betaling_2016.bedrag) AS SomVanbedrag SELECT t_betaling_2016.srt AS srt From t_betaling_2016 WHERE (t_betaling_2016.datum) >#12/31/2015# and( t_betaling_2016.datum) <#1/1/2017# GROUP BY t_betaling_2016.srt PIVOT Format(datum,'mmm') In ('jan','feb','mrt','apr','mei','jun','jul','aug','sep','okt','nov','dec');