Form Design - Monthly Cycle

Hi,

I have a table that includes several fields related to the members of a
club. To be a member of this club, you must pay $30 a month. I created a form
that I can enter a new member and his/her payment. My question is how do I
continue the tracking of the payments for the future months? For example,
suppost someone paid their dues on 10/8/2008, (that means that this person is
up do date for October), now how can I enter the payment once the month of
November reaches. Thank you.

John

John

"enter the payment" where?

Since we don't have a very clear description of your table structure (or
your form), it hard to offer any specific suggestions.

If your table were well-normalized, it might look something like:

tblPayment
PaymentID
MemberID
PaymentAmount
PaymentDate

More info, please!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"John" wrote in message
...
Hi,

I have a table that includes several fields related to the members of a
club. To be a member of this club, you must pay $30 a month. I created a
form
that I can enter a new member and his/her payment. My question is how do I
continue the tracking of the payments for the future months? For example,
suppost someone paid their dues on 10/8/2008, (that means that this person
is
up do date for October), now how can I enter the payment once the month of
November reaches. Thank you.

John

You do it with the following tables:
TblMember
MemberID
Other fields about a member

TblPaymentType
PaymentTypeID
PaymentType

TblPayment
PaymentID
MemberID
PaymentTypeID
PaymentAmount
PaymentDate

Create a form/subform where the main form is based onTblMember and the
subform is based on TblPayment. You will be able to enter new members in the
main form. You will be able to enter recurring payments by a member in the
subform. When a member makes a payment, just navigate to the member in the
main form, click the new record navigation button in the subform and enter
his payment in the subform.

Steve


"John" wrote in message
...
Hi,

I have a table that includes several fields related to the members of a
club. To be a member of this club, you must pay $30 a month. I created a
form
that I can enter a new member and his/her payment. My question is how do I
continue the tracking of the payments for the future months? For example,
suppost someone paid their dues on 10/8/2008, (that means that this person
is
up do date for October), now how can I enter the payment once the month of
November reaches. Thank you.

John

Thank you to both of you.

John

"Steve" wrote:

You do it with the following tables:
TblMember
MemberID
Other fields about a member

TblPaymentType
PaymentTypeID
PaymentType

TblPayment
PaymentID
MemberID
PaymentTypeID
PaymentAmount
PaymentDate

Create a form/subform where the main form is based onTblMember and the
subform is based on TblPayment. You will be able to enter new members in the
main form. You will be able to enter recurring payments by a member in the
subform. When a member makes a payment, just navigate to the member in the
main form, click the new record navigation button in the subform and enter
his payment in the subform.

Steve


"John" wrote in message
...
Hi,

I have a table that includes several fields related to the members of a
club. To be a member of this club, you must pay $30 a month. I created a
form
that I can enter a new member and his/her payment. My question is how do I
continue the tracking of the payments for the future months? For example,
suppost someone paid their dues on 10/8/2008, (that means that this person
is
up do date for October), now how can I enter the payment once the month of
November reaches. Thank you.

John