1 2 3 4 5 6 7 8 9 10
| SELECT [DateD'edition] AS [Date], [N°BE] AS [N° Doc], [Naturedel'Entrée]&" de "&[Fournisseur] AS [Libéllé], [CodeArt] As Code, [NomArt] As [Désignation],[QuantitéE] As [Quantité], [Unitmes] As [Unité], [CodeMagA] As [Code Mag], [NomMagA] As [Magasin], [NomMagP] As [Zone],[MoisE] As [Mois]
from R_Entrée where [NomMagP]=forms!Rélévé_FS![NomMagP] and [MoisE]=forms!Rélévé_FS![Mois]
UNION
SELECT [DateDesortie] AS [Date], [N°BS] AS [N° Doc], "Sortie pour "&[NatureSortie] AS [Libéllé], [CodeArt] As Code, [NomArt] As [Désignation],[QtéS] As [Quantité], [Unitmes] As [Unité], [CodeMagA] As [Code Mag], [NomMagA] As [Magasin], [NomMagP] As [Zone],[MoisS] As [Mois]
from R_Sortie where [NomMagP]=forms!Rélévé_FS![NomMagP] and [MoisS]=forms!Rélévé_FS![Mois]
UNION
select [DateFactureD] AS [Date], [N°Doc] AS [N° Doc], [NatureFact]&" à "&[Nomclient] AS [Libéllé], [CodeArt] As Code, [NomArt] As [Désignation],[QtéF] As [Quantité], [Unitmes] As [Unité], [CodeMagA] As [Code Mag], [NomMagA] As [Magasin], [NomMagP] As [Zone],[MoisF] As [Mois]
from R_Facture where [NomMagP]=forms!Rélévé_FS![NomMagP] and [MoisF]=forms!Rélévé_FS![Mois]
UNION select [DateFactureA] AS [Date], [N°Doc] AS [N° Doc], [NatureFact]&" de "&[Nomclient] AS [Libéllé], [CodeArt] As Code, [NomArt] As [Désignation],[QuantitéA] As [Quantité], [Unitmes] As [Unité], [CodeMagA] As [Code Mag], [NomMagA] As [Magasin], [NomMagP] As [Zone],[MoisA] As [Mois]
from R_Avoir where [NomMagP]=forms!Rélévé_FS![NomMagP] and [MoisA]=forms!Rélévé_FS![Mois]; |
Partager