RENEW DATE!

  • Thread starter Thread starter LadySugar
  • Start date Start date
L

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
 
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.
 
Criteria on JoinedDate---

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

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]
 
I have made the same mistake several time before.
Click to expand...

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

John W. Vinson [MVP]
 
Back
Top