Automatic dues

[Guest]

Hi. I have a membership database. Members have MemberDate (their
anniversary date). Members pay Membership dues every year based on their
MemberDate. I have DateCreated as the day dues are due. Then I have
PaidThrough with a control source of DateAdd("d",365,[DateCreated])

Currently, everything is manual (expect PaidThrough which is calculated). I
don't think this won't allow me to know if someone hasn't paid, since I
haven't yet created the coming dues.

I'm trying to figure out how to say that the first DateCreated is the
MemberDate.
The second DateCreated is the MemberDate plus 1 year. Somehow, I'd like
this to automated so that I know when the second DateCreated is going to be
in order to run reports.

I don't care if they pay late, as the members DateCreated (and PaidThrough)
is based on the MemberDate.

I hope I explained this well enough. Please let me know if you need
additional information. Thanks for the help.

 

[Rick B]

On post per question please.

http://www.mvps.org/access/netiquette.htm