cumulative balance field

Article View: borland.public.interbase.sql

Article #378

Back to borland.public.interbase.sql Previous Next

#378

From: Isaac
Date: Wed, 07 May 2008 23:15

7 lines
1126 bytes

Hello,
I have a table to store cash reigstery data for example:
acc_id, date, name, debit, credit and balance

I need the field "balance" to has the cumulative sum of the debit and 
the credit fields, how I create the field "balance" to display this 
information automatically ??

Technical Details

Message-ID: <4822380f@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!217.73.144.45.MISMATCH!feeder2.ecngs.de!ecngs!feeder.ecngs.de!news.isoc.lu!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,7fe0f2b0b1ac1758,start
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Thu, 08 May 2008 02:15:20 +0300
From: Isaac <no@no.com>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: cumulative balance field
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 41.234.199.133
Message-ID: <4822380f@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1210202127 41.234.199.133 (7 May 2008 16:15:27 -0700)
Lines: 7
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!217.73.144.45.MISMATCH!feeder2.ecngs.de!ecngs!feeder.ecngs.de!news.isoc.lu!newsgroups.borland.com!not-for-mail