Segregating Calculated Fields

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I have a "simple" two-table database... one that tracks
individuals... the other that tracks payments specific to
that individual. I have linked the forms so that after
searching for the correct subject in the main table, a
command button opens a payment form specific to that
subject (listing name, etc.). A command button allows
for the creation of a new payment thus tracking each new
payment made.
I have created queries that calculate the total (sum)
paid, grouped by the subject name but I can't seem to
segreate that total so that it will show up on the the
first form (subject name) updated with the most recent
payment. Linking the field to the query has the same
total for the first "group by" to appear on each subject
record. I hope this makes sense... and any help would be
appreciated.
Don
 
I'm not sure if I understand, but lets say form1 is the
individual form. On that form (hidden or not) you should
have a unique field for that individual. Lets call it
ind_key (maybe it's an autonumber). Then in the payment
table, you would also have a ind_key that is corresponds
to the individual. When your command button opens the
second form to enter a payment, put the ind_key for the
payment table on that form (hidden or not) with a default
value to show as follows =forms!form1!ind_key. This will
make sure that the new payment will made with the ind_key
from the individual table.

Mine was probably more confusing than yours, but good
luck.
 
Back
Top