1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| Set oPerimetre1 = myDb.OpenRecordset("SELECT supra_table_perimetre.id_division AS var_perimetre, " _
& "Sum(supra_table_perimetre.perf_1_01) AS perf_1_01, Sum(supra_table_perimetre.perf_1_02) AS perf_1_02, Sum(supra_table_perimetre.perf_1_03) AS perf_1_03, Sum(supra_table_perimetre.perf_1_04) AS perf_1_04, Sum(supra_table_perimetre.perf_1_05) AS perf_1_05, Sum(supra_table_perimetre.perf_1_06) AS perf_1_06, Sum(supra_table_perimetre.perf_1_07) AS perf_1_07, Sum(supra_table_perimetre.perf_1_08) AS perf_1_08, Sum(supra_table_perimetre.perf_1_09) AS perf_1_09, Sum(supra_table_perimetre.perf_1_10) AS perf_1_10, " _
& "Sum(supra_table_perimetre.perf_1_11) AS perf_1_11, Sum(supra_table_perimetre.perf_1_12) AS perf_1_12, Sum(supra_table_perimetre.perf_1_13) AS perf_1_13, Sum(supra_table_perimetre.perf_1_14) AS perf_1_14, Sum(supra_table_perimetre.perf_1_15) AS perf_1_15, Sum(supra_table_perimetre.perf_1_16) AS perf_1_16, Sum(supra_table_perimetre.perf_1_17) AS perf_1_17, Sum(supra_table_perimetre.perf_1_18) AS perf_1_18, Sum(supra_table_perimetre.perf_1_19) AS perf_1_19, Sum(supra_table_perimetre.perf_1_20) AS perf_1_20, " _
& "Sum(supra_table_perimetre.perf_1_21) AS perf_1_21, Sum(supra_table_perimetre.perf_1_22) AS perf_1_22, Sum(supra_table_perimetre.perf_1_23) AS perf_1_23, Sum(supra_table_perimetre.perf_1_24) AS perf_1_24, Sum(supra_table_perimetre.perf_1_25) AS perf_1_25, Sum(supra_table_perimetre.perf_1_26) AS perf_1_26, Sum(supra_table_perimetre.perf_1_27) AS perf_1_27, Sum(supra_table_perimetre.perf_1_28) AS perf_1_28, Sum(supra_table_perimetre.perf_1_29) AS perf_1_29, Sum(supra_table_perimetre.perf_1_30) AS perf_1_30, " _
& "Sum(supra_table_perimetre.perf_1_31) AS perf_1_31, Sum(supra_table_perimetre.perf_1_32) AS perf_1_32, Sum(supra_table_perimetre.perf_1_33) AS perf_1_33, Sum(supra_table_perimetre.perf_1_34) AS perf_1_34, Sum(supra_table_perimetre.perf_1_35) AS perf_1_35, Sum(supra_table_perimetre.perf_1_36) AS perf_1_36, Sum(supra_table_perimetre.perf_1_37) AS perf_1_37, Sum(supra_table_perimetre.perf_1_38) AS perf_1_38, Sum(supra_table_perimetre.perf_1_39) AS perf_1_39, Sum(supra_table_perimetre.perf_1_40) AS perf_1_40, " _
& "Sum(supra_table_perimetre.perf_1_41) AS perf_1_41, Sum(supra_table_perimetre.perf_1_42) AS perf_1_42, Sum(supra_table_perimetre.perf_1_43) AS perf_1_43, Sum(supra_table_perimetre.perf_1_44) AS perf_1_44, Sum(supra_table_perimetre.perf_1_45) AS perf_1_45, Sum(supra_table_perimetre.perf_1_46) AS perf_1_46, " _
& "FROM supra_table_perimetre " _
& "GROUP BY supra_table_perimetre.id_division " _
& "HAVING (((supra_table_perimetre.id_division)= " & var_division & ")) " _
& "union SELECT supra_table_perimetre.id_zone AS var_perimetre, " _
& "Sum(supra_table_perimetre.perf_1_01) AS perf_1_01, Sum(supra_table_perimetre.perf_1_02) AS perf_1_02, Sum(supra_table_perimetre.perf_1_03) AS perf_1_03, Sum(supra_table_perimetre.perf_1_04) AS perf_1_04, Sum(supra_table_perimetre.perf_1_05) AS perf_1_05, Sum(supra_table_perimetre.perf_1_06) AS perf_1_06, Sum(supra_table_perimetre.perf_1_07) AS perf_1_07, Sum(supra_table_perimetre.perf_1_08) AS perf_1_08, Sum(supra_table_perimetre.perf_1_09) AS perf_1_09, Sum(supra_table_perimetre.perf_1_10) AS perf_1_10, " _
& "Sum(supra_table_perimetre.perf_1_11) AS perf_1_11, Sum(supra_table_perimetre.perf_1_12) AS perf_1_12, Sum(supra_table_perimetre.perf_1_13) AS perf_1_13, Sum(supra_table_perimetre.perf_1_14) AS perf_1_14, Sum(supra_table_perimetre.perf_1_15) AS perf_1_15, Sum(supra_table_perimetre.perf_1_16) AS perf_1_16, Sum(supra_table_perimetre.perf_1_17) AS perf_1_17, Sum(supra_table_perimetre.perf_1_18) AS perf_1_18, Sum(supra_table_perimetre.perf_1_19) AS perf_1_19, Sum(supra_table_perimetre.perf_1_20) AS perf_1_20, " _
& "Sum(supra_table_perimetre.perf_1_21) AS perf_1_21, Sum(supra_table_perimetre.perf_1_22) AS perf_1_22, Sum(supra_table_perimetre.perf_1_23) AS perf_1_23, Sum(supra_table_perimetre.perf_1_24) AS perf_1_24, Sum(supra_table_perimetre.perf_1_25) AS perf_1_25, Sum(supra_table_perimetre.perf_1_26) AS perf_1_26, Sum(supra_table_perimetre.perf_1_27) AS perf_1_27, Sum(supra_table_perimetre.perf_1_28) AS perf_1_28, Sum(supra_table_perimetre.perf_1_29) AS perf_1_29, Sum(supra_table_perimetre.perf_1_30) AS perf_1_30, " _
& "Sum(supra_table_perimetre.perf_1_31) AS perf_1_31, Sum(supra_table_perimetre.perf_1_32) AS perf_1_32, Sum(supra_table_perimetre.perf_1_33) AS perf_1_33, Sum(supra_table_perimetre.perf_1_34) AS perf_1_34, Sum(supra_table_perimetre.perf_1_35) AS perf_1_35, Sum(supra_table_perimetre.perf_1_36) AS perf_1_36, Sum(supra_table_perimetre.perf_1_37) AS perf_1_37, Sum(supra_table_perimetre.perf_1_38) AS perf_1_38, Sum(supra_table_perimetre.perf_1_39) AS perf_1_39, Sum(supra_table_perimetre.perf_1_40) AS perf_1_40, " _
& "Sum(supra_table_perimetre.perf_1_41) AS perf_1_41, Sum(supra_table_perimetre.perf_1_42) AS perf_1_42, Sum(supra_table_perimetre.perf_1_43) AS perf_1_43, Sum(supra_table_perimetre.perf_1_44) AS perf_1_44, Sum(supra_table_perimetre.perf_1_45) AS perf_1_45, Sum(supra_table_perimetre.perf_1_46) AS perf_1_46, " _
& "FROM supra_table_perimetre " _
& "GROUP BY supra_table_perimetre.id_zone " _
& "HAVING (((supra_table_perimetre.id_zone)= " & var_zone & "));") |
Partager