Re: Calculated value dilemma

From: Tony Toews [MVP] <>
Date: Wed, 16 Jul 2008 20:17:31 GMT
Message-ID: <>

Rainboy <> wrote:

>As keeping historically accurate info is important, 'hard-coding' the
>balance in the table seems to me like it might be the most appropriate

Put the balance on the parent table. But also create a method of double checking that number by adding up the individual transactions, telling the user there is a problem, log that problem so they can bring it to your attention at a later date and then fix the balance. Also create this method before even coding the logic to update the balance. Thus you can use it as part of your testing.


Tony Toews, Microsoft Access MVP
   Please respond only in the newsgroups so that others can 
read the entire thread of messages.
   Microsoft Access Links, Hints, Tips & Accounting Systems at
   Tony's Microsoft Access Blog -
Received on Wed Jul 16 2008 - 22:17:31 CEST

Original text of this message