Improve company productivity with a Business Account.Sign Up

x
?
Solved

Renew a membership record

Posted on 2002-03-04
3
Medium Priority
?
340 Views
Last Modified: 2012-08-13
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
0
Comment
Question by:Sul05
  • 2
3 Comments
 
LVL 54

Accepted Solution

by:
nico5038 earned 200 total points
ID: 6839183
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
 
LVL 54

Expert Comment

by:nico5038
ID: 7048473
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
 
LVL 5

Expert Comment

by:Netminder
ID: 7064443
Per recommendation, force-accepted by
Netminder
CS Moderator
0

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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.

Join & Write a Comment

Implementing simple internal controls in the Microsoft Access application.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question