Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    2

    Question Unanswered: Calculating BBF in query or form for inserting in a table

    I know that question regarding Balance brought forward has been raised here several times but I wasn't able to find the answer on my problem:
    The database is made from simple template LEDGER of ACCESS XP, with WITHDRAWALAMOUNT and DEPOSITAMOUNT fields in table, I added also field called BALANCE...At this point my knowledge stopped
    I need the Balance Brought Forward to be calculated in update query and inserted into a table for further showing in a form and in reports.
    I was thinking about DSUM but can't get how to make it work...I was tlkaing to another person who said that better would be to make lookup for previous record copy it into balance field and then summarize/deduct accordingly...I do understand in theory how it should be done but can't get it working in a reality.
    Did anyone had the same problem?

  2. #2
    Join Date
    Oct 2004
    Posts
    2

    Question So nobody knows how to do it?

    As far as I can see other threads were looked through...Mine seems to be quite difficult or what?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •