New Database for membership and collecting Dues

[Guest]

I have a new database with a table for membership and their personal data. A
table for dues structure, a table for years of membership.

I need help on designing the dues calcualtion portion. Each year the
memberhsip will get a dues statement generated. I need to calculate what
they owe for that year and any past years that are not paid.

Can someone help me with this?

Thanks, Keith

 

[John Vinson]

I have a new database with a table for membership and their personal data. A
table for dues structure, a table for years of membership.

I need help on designing the dues calcualtion portion. Each year the
memberhsip will get a dues statement generated. I need to calculate what
they owe for that year and any past years that are not paid.

Can someone help me with this?

Probably, but not without knowing more about your table structure and
the rules by which the dues are calculated.

I'd suggest (at least) two tables in a one to many relationship:
Members and Renewals. Each renewal record would record the date of the
renewal, dues paid, and whatever other information you need to meet
your requirements. This may be what you mean by "table for years of
membership" but I'm not sure!

John W. Vinson[MVP]

 

[Guest]

John,

I have 3 tables. One is a membership table which comprises all information
on each member, name, address, other personal info. One is Dues and one is
payments. Dues are collected once each year. I would need to send out a
dues notice to each member and have on it what they owe. Sometimes they
could be a year or two behind so I would have to list each year and the
total. Does that explain the situation?