Clheckbook Register using VB-2010
I've created a VB 2010 application that uses a SQL database. I need to learn how to calculate a balance column from data entered in a debit or deposit column.
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
>>I need to learn how to calculate a balance column from data entered in a debit or deposit column.
Basically you need to know the logic on how to calculate it, whether it's just a simple summation of column's values or some filtering criteria or logic are being involved.
it also depends on what kind of database you are using so that we know what syntax is to be used for the calculation. but as a start, I guess you need to use SUM clause in your SQL statement, like:
Basically you need to know the logic on how to calculate it, whether it's just a simple summation of column's values or some filtering criteria or logic are being involved.
it also depends on what kind of database you are using so that we know what syntax is to be used for the calculation. but as a start, I guess you need to use SUM clause in your SQL statement, like:
select category, sum(yourDepositField) as bal from yourTable where yourAnotherfield = <whatever> group by category
Premium Content
You need an Expert Office subscription to comment.Start Free Trial