H
HL
Hello,
I have a form with the following fields:
MemberID, First Name, Last Name, Payment Amount, Date, Payment Method,
Notes.
My problem is that the MemberID, First Name, and Last Name for a specific
person will not change however the Payment Amount, Date, & Payment Method
will change each week for the person.
How do I keep the Member ID, First Name, and Last Name the same for the
record but update the Payment Amount, Date & Payment Method each week?
Not only do I need to update the Payment Amount, Date, & Payment Method each
week for specific records but I need to keep a running total of these items
so that I can make a print out for the month. The monthly statement should
tell how much the person paid per week and the total for the month.
Thanks for the help.
I have a form with the following fields:
MemberID, First Name, Last Name, Payment Amount, Date, Payment Method,
Notes.
My problem is that the MemberID, First Name, and Last Name for a specific
person will not change however the Payment Amount, Date, & Payment Method
will change each week for the person.
How do I keep the Member ID, First Name, and Last Name the same for the
record but update the Payment Amount, Date & Payment Method each week?
Not only do I need to update the Payment Amount, Date, & Payment Method each
week for specific records but I need to keep a running total of these items
so that I can make a print out for the month. The monthly statement should
tell how much the person paid per week and the total for the month.
Thanks for the help.