Tables

  • Thread starter Thread starter Herman Jones
  • Start date Start date
H

Herman Jones

I HAVE A PROBLEM WITH MY FORM- I HAVE NAMES AND ADDRESS
FIELDS AND DATA ENTRY MONEY AMOUNTS LIKE OFFERING, EACH
WEEK I PULL UP THE PERSON NAME TO ADD HIS DONATION FOR
THIS WEEK THE LAST WEEK AMOUNT IS THERE,THEN I HAVE TO
USE A CALCALATOR TO ADD THE NEW AMOUNT TO THE OLD AMOUNT
IS THERE A WAY TO JUST ENTER THE NEW AMOUNT AND IT ADD
AUTOMATIC, IF SO PLEASE SHOW ME HOW THANK YOU HERMAN.
 
I HAVE A PROBLEM WITH MY FORM- I HAVE NAMES AND ADDRESS
FIELDS AND DATA ENTRY MONEY AMOUNTS LIKE OFFERING, EACH
WEEK I PULL UP THE PERSON NAME TO ADD HIS DONATION FOR
THIS WEEK THE LAST WEEK AMOUNT IS THERE,THEN I HAVE TO
USE A CALCALATOR TO ADD THE NEW AMOUNT TO THE OLD AMOUNT
IS THERE A WAY TO JUST ENTER THE NEW AMOUNT AND IT ADD
AUTOMATIC, IF SO PLEASE SHOW ME HOW THANK YOU HERMAN.
Click to expand...

First off... typing in all caps is hard to read and impolite: it looks
like you're SHOUTING AT US. Please use all lower case if the shift key
is difficult for you.

I think the problem is not your Form, but your table structure. Each
payment should be in a *new record* in a second table, related one to
many to the names table. You can easily create a Totals query to sum
the payments, or even put a Subform on the People form for payments;
in the subform's Footer put a textbox with a control source

=Sum([payments])

to calculate the total of all the payments dynamically. It would be
neither necessary nor beneficial to store this total in your table.
 
Back
Top