Solved

Renew a membership record

Posted on 2002-03-04
3
330 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 50 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

815 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now