rachidos001
Messages postés
44
Date d'inscription
mardi 12 avril 2005
Statut
Membre
Dernière intervention
23 mars 2006
20 mars 2006 à 10:12
la requette access est comme suit:
SELECT [Dept] AS Département, [Operation] AS Opération, [commande].[N°com] AS N°Commande, [Date_recp] AS [Date Récp], [Date_trans] AS [Date Trans], [Date_aff] AS [Date Aff], [Centre], [Client], [Fournisseur], [Design_mat] AS Désignation, [Confir] AS Confirmation, [Date_confir] AS [Date Confirm], [Obser] AS Observation1, [N°Fact] AS N°Facture, [Date_Fact] AS [Date Fact], [Montant], [Devise], [Nbr_Colis] AS [Nbr Colis], [Poids], [Trans] AS Transporteur, [Moy] AS Moyen, [Date_arriv] AS [Date Arrivée], [N°Avis], [Doc] AS [Document Joint], [N°Doc], [facture].[N°OT] AS N°OT, [Date_OT] AS [Date OT], [Sit] AS Transitaire, [N°Inst] AS N°Instance, [Date_inst] AS [Date Instance], [N°Ordre] AS N°Assurance, [Obser2] AS Observation2
FROM (commandeLEFT JOINfacture ON ([commande].[N°com]= [facture].[N°Com]) AND ([commande].[operation]=[facture].[operat])) LEFT JOIN Instance ON [facture].[N°OT] =[Instance].[N°OT];
Les Tables:
<LI>Commande ( Dept, Operation, N°com, Date_recp, Date_trans, Date_aff, Centre, Client, Fournisseur, Design_mat, Confir, Date_confir, Obser )</LI>
<LI>Facture ( N°Fact, Date_Fact, Montant, Devise, Nbr_Colis, Poids, Trans,Moy, Date_arriv, N°Avis, Doc,N°Doc,N°OT,Date_OT, Sit )</LI>
<LI>Instance ( N°Inst, Date_inst, N°Ordre, Obser2 )</LI>
merci encore mon ami pour votre aide