Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Renew a membership record

Posted on 2002-03-04
3
Medium Priority
?
338 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

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

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

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

572 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