Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Query with a running total
Versions des environnements
Hi all,
Does VFP9 offer any simple solutions to the following situation?
I am trying to create a view, which among others, has 4 fields- Date, Debit, Credit, and Balance-(which is the present running cash balance). For the Balance, it requires the (sum of all credits)-(sum of all debits), but only upto that date, or entry. My problem is, that when I specify it that way, I get only one row in the view, showing the total of all debits and all credits for the entire table. Could someone help me with this one ? Thanks.
Regards,
Steve.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement