General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Query with a running total
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only