Results 1 to 2 of 2

Thread: balance

  1. #1
    Join Date
    Jun 2004

    Unanswered: balance


    I created a db called tuition

    The fields in tuiton are: Students Name, Beginning Balance, Payment amount, date of payment, next payment due, amount of next payment.

    When I click on tuition db from mainmenu, and go to student name choose the student I want, and once chosen Beginning balance automatically enters the balance(previous month balance-payment amount) into the field.

    Is this possible?

    Sorry if this is not clear trying my best!


  2. #2
    Join Date
    Sep 2003

    Set Field

    You can complete that with the script step set field.

    Set field (balance) = Balance - last payment amount

    Not the best way to keep track of this sort of thing, but it will work.

    You really want to keep a charges database and a payments database and use the Sum function in a calculation to determine the balance due.

Posting Permissions

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