1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| SELECT CodeVersementClient AS CodeOperation, 'Paiement Client' AS TypeOperation, DateVersementClient AS DateOperation, HeureVersementClient AS HeureOperation, NomClient AS Nom, MtVersementClient AS MtOperation, [Note], UserName
FROM (T_Clients INNER JOIN T_VersementsClients ON T_Clients.CodeClient = T_VersementsClients.CodeClient) INNER JOIN T_Users ON T_VersementsClients.UserIdVersementClient = T_Users.UserId
WHERE ModePaiement = 'Espèces' AND DateVersementClient >= [Formulaires]![FinancesCaisse_F]![DateDebut] And DateVersementClient <= [Formulaires]![FinancesCaisse_F]![DateFin]
UNION ALL
SELECT CodeVersementAuFournisseur AS CodeOperation, 'Paiement Fournisseur' AS TypeOperation, DateVersementAuFournisseur AS DateOperation, HeureVersementAuFournisseur AS HeureOperation, NomFournisseur AS Nom, MtVersementAuFournisseur AS MtOperation, [Note], UserName
FROM (T_Fournisseurs INNER JOIN T_VersementsAuxFournisseurs ON T_Fournisseurs.CodeFournisseur = T_VersementsAuxFournisseurs.CodeFournisseur) INNER JOIN T_Users ON T_VersementsAuxFournisseurs.UserIdVersementAuFournisseur = T_Users.UserId
WHERE ModePaiement = 'Espèces' AND (DateVersementAuFournisseur >= [Formulaires]![FinancesCaisse_F]![DateDebut] And DateVersementAuFournisseur <= [Formulaires]![FinancesCaisse_F]![DateFin])
UNION ALL
SELECT T_Depenses.CodeDepense AS CodeOperation, 'Dépense' AS TypeOperation, T_Depenses.DateDepense AS DateOperation, T_Depenses.HeureDepense AS HeureOperation, T_DepensesLibelles.LibelleDepense AS Nom, T_Depenses.MontantDepense AS MtOperation, T_Depenses.[Note], T_Users.UserName
FROM T_DepensesLibelles INNER JOIN (T_Depenses INNER JOIN T_Users ON T_Depenses.UserIdDepense = T_Users.UserId) ON T_DepensesLibelles.CodeLibelleDepenses = T_Depenses.CodeLibelleDepenses
WHERE T_Depenses.DateDepense >= [Formulaires]![FinancesCaisse_F]![DateDebut] And T_Depenses.DateDepense <= [Formulaires]![FinancesCaisse_F]![DateFin]
UNION ALL
SELECT PersonnelOperations_R.NumOperationPersonnel AS CodeOperation, IIf([CodeLibelleOpPersonnel]=4,"Acomptes",IIf([CodeLibelleOpPersonnel]=5,"Crédit","Paiement Salaire")) AS TypeOperation, PersonnelOperations_R.DateOperationPersonnel, PersonnelOperations_R.HeureOperationPersonnel, [NomPersonnel] & " " & [PrenomPersonnel] AS Nom, MtOperationPersonnel+0 AS MtOperation, "" AS [Note], T_Users.UserName
FROM T_Users INNER JOIN (PersonnelOperations_R INNER JOIN T_Personnel ON PersonnelOperations_R.CodePersonnel = T_Personnel.CodePersonnel) ON T_Users.UserId = PersonnelOperations_R.UserIdOpPersonnel
WHERE (((PersonnelOperations_R.CodeLibelleOpPersonnel)=4 Or (PersonnelOperations_R.CodeLibelleOpPersonnel)=5 Or (PersonnelOperations_R.CodeLibelleOpPersonnel)=6)) AND PersonnelOperations_R.DateOperationPersonnel >= [Formulaires]![FinancesCaisse_F]![DateDebut] And PersonnelOperations_R.DateOperationPersonnel <= [Formulaires]![FinancesCaisse_F]![DateFin]
ORDER BY DateOperation, HeureOperation; |
Partager