RENEW DATE!

[LadySugar]

Greetings! I have a database in access that contains information
about the date members joined the company. Every year, membership
must be renewed for each member. Usually I will send out a standard
letter from a report to each member regardless of the date they
joined. Members are only supposed to receive letters an exact year
after they joined. I am wondering if it is possible for me to do a
setting that will let me to create reports and send letters that will
be a year from the exact date a member joined.
I will appreciate help in this

Regards,
L.S

 

[kingston via AccessMonster.com]

How about creating a procedure that you run once a week based on a query that
does something like:

SELECT MemberInfo FROM Members WHERE "#" & Month([JoinDate]) & "/" & Day(
[JoinDate]) & "/" & Year(Date()) & "#" Between Date()-6 And Date();

This would return a list of members whose anniversary was in the past week.

 

[KARL DEWEY]

Criteria on JoinedDate---

=DateAdd("y",-1,Date())

This will subtract one year from current date ( Date() ) and check if
JoinedDate is greater or equal.

 

[John W. Vinson]

Criteria on JoinedDate---

This will subtract one year from current date ( Date() ) and check if
JoinedDate is greater or equal.

I think Karl meant to say "yyyy" - very confusingly, the "y" operand means one
day (a day of the year I guess).

John W. Vinson [MVP]

 

[KARL DEWEY]

I have made the same mistake several time before.

 

[John W. Vinson]

I have made the same mistake several time before.

and that's exactly why I remember it now... that little pest has bitten me
several times!

John W. Vinson [MVP]