Automatic dues

S

Stephanie

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automating dues 2
After renewing my subscription my family members get a renewal message 0
Automatic Emails sent to my Contact Groups by Microsoft 1
Can This Be Done in Excel? 3
Count Records for this week, this month, this quarter and this yea 2
A Weekly Count 3
Dues Query 2
Auto store date created & updated, EmpId created by and Updated by 1

Top