Clheckbook Register using VB-2010

kb4zq
kb4zq used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software Team Lead
Commented:
>>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:

select category, sum(yourDepositField) as bal from yourTable where yourAnotherfield = <whatever> group by category

Open in new window

Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial