RS.Open "SELECT transfert.NUM_TRANS, transfert.LIEU_TRANS, eleve.NUM FROM transfert INNER JOIN eleve ON eleve.NUM = transfert.NUM WHERE transfert.NUM_TRANS=" & Val(NUM_TRANS) & " And eleve.NUM = " & Val(NUM), CN"
RS.Open "SELECT transfert.NUM_TRANS, transfert.LIEU_TRANS, eleve.NUM FROM transfert INNER JOIN eleve ON eleve.NUM = transfert.NUM WHERE transfert.NUM_TRANS=" & Val(NUM_TRANS) & " And eleve.NUM = " & Val(NUM)
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionRS.Open "SELECT transfert.NUM_TRANS, " & _ " transfert.LIEU_TRANS, " & _ " eleve.NUM " & _ " FROM transfert " & _ " INNER JOIN eleve ON eleve.NUM = transfert.NUM " & _ " WHERE transfert.NUM_TRANS = " & CStr(NUM_TRANS) & _ " And eleve.NUM = " & CStr(NUM), CN