Results 1 to 8 of 8

Thread: Balance Field in MS Access

Threaded View

  1. Oct 12th, 2005, 10:30 AM #7
    raketekc
    raketekc is offline

    Thread Starter
    New Member
    Join Date
    Sep 2005
    Posts
    15

    Re: Balance Field in MS Access

    Thanks guys for your response but i can't seem to get it. My tabel is like this

    ID DETAIL DEBIT BALANCE
    B/forward $300
    1 JOHN $100 $200
    2 PETER $50 $150
    3 ANDREW $50 $100

    Now if i make a change to entry number 2 (PETER), say i put $100 , then my closing balance remains $100 instead of $0. Now i want when i change entry number 2(PETER) the balance field to automatically adjust itself.

    I hope this illustration will help you to see my situation. If there is a way around this please help me get round it.
    Last edited by raketekc; Oct 12th, 2005 at 10:36 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width