Help writing an expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need help writing an expression for checkbook register with running balance.
Deposit - withdrawal - balance
 
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
 
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]
 
Back
Top