Renew a membership record

Hey,
I,ve got a simple database for a leisure center.  I have manages to carry out most of the work but i need help on none small aspect.  The problem is that memberships at the gym need renewing annually and i need help to create this function.  Could you please solve this small task for me.
Thanx Sully
LVL 2
Sul05Asked:
Who is Participating?
 
nico5038Commented:
You can use a query to identify the renewals by enterin in the criteria underneath the "LastRenewalDate"
<dateserial(year([LastRenewalDate])-1,month([LastRenewalDate]),day([LastRenewalDate]))

This will list all with an expired renewal date.
Need more?

Nic;o)
0
 
nico5038Commented:
for Sul05

No comment has been added for the last two months.
So it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
 - Answered by: nico5038  
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 
NetminderCommented:
Per recommendation, force-accepted by
Netminder
CS Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.