Table Manipulations and Calculations 1

[CyrusAyers]

I am working on an Access 2000 project that takes in charge tickets, stores account holder info by month/year (like previous balance, accrued finance charge, etc.), and prints about 6 various reports including monthly statements, summaries, and tax exemption listings.
The project needs the ability to move a "Charge Sum" over to the "Beginning Balance" for the next month (and preform finance calculations, etc.) All values are currently on the same table.
*May I ask by what means this could be best accomplished? VBA code? (Im a little shaky on table reference/manipulation, but once im in, i can do the VB if/then etc...) Could you help with this?

 

[Rolliee]

VBA code, by all means. If you want me to send you a sample, send me your email asking and I will get it on my pro bono list and return a zipped example in the next couple of days. Explain the problem so I can construct my sample tables as you wish them to be.

rollie@bwsys.net