Need a Balance Due field & monthly payments

[Guest]

I did not create my database.
I need to be able to look at my payments form and see the total amount due
at time of sign up, then see thepayments made, and the remaining balance.

 

[Guest]

It's hard to advise you without knowing something about your tables, but in
general, you want to calculate the Balance Due by subtracting the payments
from the charges, something like:

=Sum([Debits]) - Sum([Credits])

Hope that helps.
Sprinks

 

[Guest]

Did u get my previous response?? I don't see it posted anywhere, and i wanted
to make sure it's not lost in cyber space.

It's hard to advise you without knowing something about your tables, but in
general, you want to calculate the Balance Due by subtracting the payments
from the charges, something like:

=Sum([Debits]) - Sum([Credits])

Hope that helps.
Sprinks

I did not create my database.
I need to be able to look at my payments form and see the total amount due
at time of sign up, then see thepayments made, and the remaining balance.

 

[Guest]

No.

Did u get my previous response?? I don't see it posted anywhere, and i wanted
to make sure it's not lost in cyber space.

It's hard to advise you without knowing something about your tables, but in
general, you want to calculate the Balance Due by subtracting the payments
from the charges, something like:

=Sum([Debits]) - Sum([Credits])

Hope that helps.
Sprinks

I did not create my database.
I need to be able to look at my payments form and see the total amount due
at time of sign up, then see thepayments made, and the remaining balance.

 

[Guest]

Gald I double checked.
Here we go again.

Currently my db is set up so that on each row, I enter each new payment
information: date, amount, cash, etc.
I tried to add a few more fields so that I could enter the Total balance
due, payment 1, new balance, etc. where the new balance= Total - payment
It worked, BUT is row independent.
So when i go to enter a new payment, the new row (which is autoNumber
generated) is blank and does not contain the balance information from the
previous row.

I would like to be able to have a field that say Total balance due, at least.
My ultimate goal is to also have another field that says Remaining balance
(that would be based on the Total - Payments).

Make better sense?

No.

Did u get my previous response?? I don't see it posted anywhere, and i wanted
to make sure it's not lost in cyber space.

It's hard to advise you without knowing something about your tables, but in
general, you want to calculate the Balance Due by subtracting the payments
from the charges, something like:

=Sum([Debits]) - Sum([Credits])

Hope that helps.
Sprinks

:

I did not create my database.
I need to be able to look at my payments form and see the total amount due
at time of sign up, then see thepayments made, and the remaining balance.

 

[Guest]

You do NOT enter calculated data (like balance due) into fields of a table.
Such data is calculated on the fly by a query for display or printing. If you
provide more info on the structure of your payments table, we can assist you.

 

[fukazawa]

Gald I double checked.
Here we go again.

Currently my db is set up so that on each row, I enter each new payment
information: date, amount, cash, etc.
I tried to add a few more fields so that I could enter the Total balance
due, payment 1, new balance, etc. where the new balance= Total - payment
It worked, BUT is row independent.
So when i go to enter a new payment, the new row (which is autoNumber
generated) is blank and does not contain the balance information from the
previous row.

I would like to be able to have a field that say Total balance due, at least.
My ultimate goal is to also have another field that says Remaining balance
(that would be based on the Total - Payments).

Make better sense?

No.

Did u get my previous response?? I don't see it posted anywhere, and i wanted
to make sure it's not lost in cyber space.

:

It's hard to advise you without knowing something about your tables, but in
general, you want to calculate the Balance Due by subtracting the payments
from the charges, something like:

=Sum([Debits]) - Sum([Credits])

Hope that helps.
Sprinks

:

I did not create my database.
I need to be able to look at my payments form and see the total amount due
at time of sign up, then see thepayments made, and the remaining

balance.

 

[Guest]

I have a similar question. we collect fees in 2 terms. I am able to get the
balance due but i want to filter the balances based on each term. How do i
check for a particular term. And also If any balances still available in the
1st term has to be carried forward to the 2nd term total.

pls help