1 2 3 4 5 6 7 8
| RR05 = "SELECT T_r09.clef, T_r09.semaine, T_r09.agregat, T_r09.[tot agregat], T_r09.[code fam pdt], T_r09.[lib fam pdt], T_r09.[annee-sem], T_r09.prev_s, T_r09.cde_s, T_r09.prev_s1, T_r09.cde_s1, T_r09.liv_s1, T_r09.[lib ref], T_r09.lib_grc4, T_r09.ecart, IIf([annee_debut]>[annee],"",IIf([sem_db]<=[semaine],IIf([sem_fin]>=[semaine],[code_op].[code op],IIf([annee_fin]>[annee],[code_op].[code op],"")),IIf([annee]>[annee_debut],IIf([sem_fin]>=[semaine],IIf([annee_fin]>=[annee],[code_op].[code op],""),IIf([annee_fin]>[annee],[code_op].[code op],"")),""))) AS [Code OP], Left([T_r09].[clef],6) AS [Code ref], code_op.sem_db, code_op.sem_fin INTO T_cd_op " & _
"FROM code_op RIGHT JOIN T_r09 ON code_op.clef = T_r09.clef " & _
"GROUP BY T_r09.clef, T_r09.semaine, T_r09.agregat, T_r09.[tot agregat], T_r09.[code fam pdt], T_r09.[lib fam pdt], T_r09.[annee-sem], T_r09.prev_s, T_r09.cde_s, T_r09.prev_s1, T_r09.cde_s1, T_r09.liv_s1, T_r09.[lib ref], T_r09.lib_grc4, T_r09.ecart, IIf([annee_debut]>[annee],"",IIf([sem_db]<=[semaine],IIf([sem_fin]>=[semaine],[code_op].[code op],IIf([annee_fin]>[annee],[code_op].[code op],"")),IIf([annee]>[annee_debut],IIf([sem_fin]>=[semaine],IIf([annee_fin]>=[annee],[code_op].[code op],""),IIf([annee_fin]>[annee],[code_op].[code op],"")),""))), Left([T_r09].[clef],6), code_op.sem_db, code_op.sem_fin;"
Dim RS As DAO.Recordset
strSQL = RR05
Set RS = CurrentDb.OpenRecordset(strSQL) |
Partager