1 2 3 4 5 6
|
titre requête tblfacture pris+solde
SELECT [tblfacture pris].id_facture, [tblfacture pris].date_de_paiement, [tblfacture pris].date_de_facture, [tblfacture pris].id_fournisseur, [tblfacture pris].nom, [tblfacture pris].description,
[tblfacture pris].debit, [tblfacture pris].credit, [tblfacture pris].type, [tblfacture pris].payer, [tblfacture pris].[entre deux mois], [tblfacture pris].pris,
Nz(DSum(" [credit]","tblfacture pris","id_facture<=" & [id_facture]))-Nz(DSum(" [debit] ","tblfacture pris","id_facture <=" & [id_facture])) AS solde
FROM [tblfacture pris]; |
Partager