Help writing an expression

G

GailJr

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

Tom Wickerath

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
 
J

John Vinson

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

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]
 
Top