Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to deduct an amount from beginning balance? (Checkbook)

Status
Not open for further replies.

winston01

Programmer
May 31, 2005
37
US
Good morning. I am trying to put the company budget on access. I have set up a table that looks just like a checkbook ledger. How do I incorporate a beginning balance? I need each item to subtract or add from the balance and give a new balance? I am assuming you put the beginning balance in another table and pull it in, but how? I appreciate any help anyone can give me. Thank you and have a greatd day.

 
Hi
There are several ways to look up tables, Dlookup for example:
Dlookup("MyBalanceField", "MyLedgerTable")

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top