Help writing an expression

[Guest]

Need help writing an expression for checkbook register with running balance.
Deposit - withdrawal - balance

 

[Guest]

Something similar is the odometer example given in this KB article:
Referring to a Field in the Previous Record or Next Record
http://support.microsoft.com/?id=210504

Also, check out this thread and try downloading the sample that Max mentions
in the first message:

http://www.microsoft.com/office/com...cess&mid=f5ea3ce9-08fe-45fb-b6dd-ee95b2cf4c7d

You'll need to implement the fix discussed in this thread, in order to have
a properly functioning template.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Need help writing an expression for checkbook register with running balance.
Deposit - withdrawal - balance

 

[John Vinson]

Need help writing an expression for checkbook register with running balance.
Deposit - withdrawal - balance

If this is for a homework assignment... read your assignment.
If this is for a home-built checking account monitor database...
Microsoft Money, Quicken (though I really can't recommend it now that
Intuit's screwed it up so badly), and dozens of inexpnsive, shareware,
or freeware checking account programs are available. It makes NO sense
to reinvent one.

That said...

=[OriginalBalance] + DSum([Deposits]) - DSum([Withdrawals])

is one possibility, depending on the structure of your table (which
you have not posted nor asked about).

John W. Vinson[MVP]