1 2 3 4
| SELECT Client.[ID client], Client.Civilite, Client.Nom, Client.Prenom, Client.[adresse mail], Last([commandes 5 ans].[date de commande]) AS [DernierDedate de commande], Client.[Type de client], Client.NumBVP, [commandes 5 ans].[type ]
FROM Client INNER JOIN [commandes 5 ans] ON Client.[ID client] = [commandes 5 ans].IDcli
GROUP BY Client.[ID client], Client.Civilite, Client.Nom, Client.Prenom, Client.[adresse mail], Client.[Type de client], Client.NumBVP, [commandes 5 ans].[type ], Client.[Accord Mailing], Client.sc06altriarejet, Client.[Date fin de droit]
HAVING (((Client.[adresse mail]) Is Not Null) AND ((Last([commandes 5 ans].[date de commande]))<#3/6/2006#) AND (([commandes 5 ans].[type ])="cd" Or ([commandes 5 ans].[type ])="dvd") |
Partager