1 2 3 4
| SELECT Feuil1.NUM, Feuil1.NOM, Feuil1.Prénom, Feuil1.ADRESSE, Feuil1.CP, Feuil1.VILLE, Feuil1.Mail, DEVIS.SOURCE, DEVIS.[INDICE DE CONFIANCE], DEVIS.[INDICE DE PRIORITE], DEVIS.[DEVIS A FAIRE], DEVIS.[DEVIS FAIT LE], DEVIS.[DEVIS REMIS LE], IMPLANTATION.[Plan a faire], IMPLANTATION.[Plan fait le], MODIFICATIONS.[MODIFS A FAIRE POUR LE], MODIFICATIONS.PLAN, MODIFICATIONS.DEVIS, MODIFICATIONS.[MODIFS FAITE LE], MODIFICATIONS.[MODIFS REMISENT LE], RENDEZVOUS.[RDV A PRENDRE], RENDEZVOUS.[RDV 2], RENDEZVOUS.[OBJET RDV 2], RENDEZVOUS.[RDV 3], RENDEZVOUS.[OBJET RDV 3], RENDEZVOUS.[RDV 4], RENDEZVOUS.[OBJET RDV 4], RELANCES.[A RELANCER], RELANCES.[RELANCE 1 FAITE LE], RELANCES.[REPONSE 1], RELANCES.[RELANCE 2 FAITE LE], RELANCES.[REPONSE 2], RELANCES.[RELANCE 3 FAITE LE], RELANCES.[REPONSE 3], DEVIS.Commentaires, Feuil1.[DATE POSE PREVUE], Feuil1.[date signature]
FROM ((((Feuil1 INNER JOIN DEVIS ON Feuil1.NUM = DEVIS.NUM) INNER JOIN IMPLANTATION ON Feuil1.NUM = IMPLANTATION.NUM) INNER JOIN MODIFICATIONS ON Feuil1.NUM = MODIFICATIONS.NUM) INNER JOIN RENDEZVOUS ON Feuil1.NUM = RENDEZVOUS.NUM) INNER JOIN RELANCES ON Feuil1.NUM = RELANCES.NUM
WHERE (((Feuil1.[date signature]) Is Null)) AND ((Not (RELANCES.[REPONSE 1])="PROJET ABANDONNE")) AND ((Not (RELANCES.[REPONSE 2])="PROJET ABANDONNE")) AND ((Not (RELANCES.[REPONSE 3])="PROJET ABANDONNE"))
ORDER BY Feuil1.NOM; |
Partager