go to post Tristan Meziere · Dec 13, 2021 Hi Robert, I confirmed I can make like this : SELECT Semaine, SUM(Dicos) AS Dictionnaires, SUM(Gen) AS Généralités, SUM(Philo) AS Philosophie, SUM(Religion) AS Religion, SUM(SHS) AS SHS, SUM(Sciences) AS Sciences, SUM(Tech) AS Technique, SUM(Arts) AS Arts, SUM(Litt) AS Littérature, SUM(HisGeo) AS "Histoire - Géographie"FROM (SELECT {fn WEEK(rcddate)} AS "Semaine",CASE {fn LEFT(cot,1)}WHEN '(' THEN 1END Dicos,CASE {fn LEFT(cot,1)}WHEN '0' THEN 1END Gen,CASE {fn LEFT(cot,1)}WHEN '1' THEN 1END Philo,CASE {fn LEFT(cot,1)}WHEN '2' THEN 1END Religion,CASE {fn LEFT(cot,1)}WHEN '3' THEN 1END SHS,CASE {fn LEFT(cot,1)}WHEN '5' THEN 1END Sciences,CASE {fn LEFT(cot,1)}WHEN '6' THEN 1END Tech,CASE {fn LEFT(cot,1)}WHEN '7' THEN 1END Arts,CASE {fn LEFT(cot,1)}WHEN '8' THEN 1END Litt,CASE {fn LEFT(cot,1)}WHEN '9' THEN 1END HisGeoFROM BCSCAN)GROUP By Semaine Sorry for the long time for the response... I've lost my tourist visa "Server Administrator" for two weeks at my job because security reasons and it's not completely resolved... Many thanks
go to post Tristan Meziere · Nov 26, 2021 Hi, It's another way ... but it smells the right way ! ;-) Many thanks