(query) move old members to another table

[ranjah]

Hi all,

My database is a simple membership database that adds members and by clicking of a button it tells me the memebers birthdays for the month and if i chose to select the send card option then it remembers who has been send the card.

All i want now is a query that will take a member who's memebrship has been expired (since membership is year long only) and move them to another table by looking at the membership dates (like 2004 and 2003).

And may be later on if those members wants to join the membership i can then add them again from that table back to the main table.


I hope i made my self clear enough.

Thanks alot

 

[RV]

Rather use membership dates.
Requires to set up another table tblMembership and to create a 1 to many relationship between the membership and member tables.

RV

 

[ranjah]

Since i am new to access do you think may be you can help me step by step??
thanks alot

 

[RV]

Your member table will have a primary key, let's say it's called MemberID.
Now create a new table tblMembership containg these columns:

- MembershipID (autonumber, Primary Key)
- StartDate (date)
- EndDate (date)
- MemberID (numeric, Foreign Key)

Now define a cascading update relationship between the tables in the Relationships window.

Create forms to maintain your member data.
Enter the EndDate whenever a member retires.
Base your form on a query that will exclude members not having an active membership.

Try this approach for yourself first, give yourself some time to figure out what to do.
Come back whenever you really might get stuck.

RV

 

[ranjah]

Your member table will have a primary key, let's say it's called MemberID.
Now create a new table tblMembership containg these columns:

- MembershipID (autonumber, Primary Key)
- StartDate (date)
- EndDate (date)
- MemberID (numeric, Foreign Key)

Now define a cascading update relationship between the tables in the Relationships window.

Create forms to maintain your member data.
Enter the EndDate whenever a member retires.
Base your form on a query that will exclude members not having an active membership.

Try this approach for yourself first, give yourself some time to figure out what to do.
Come back whenever you really might get stuck.

RV

Thanks alot RV
before i try that method i found this string that actually did what i wanted to do about 85% of it.
>#1/1/2000# and <#12/31/2005# in the criteria window

problem with that is i have to change the year after every year when membership expires. Also i am still trying to figure out how to move them afterwords to a different table.

What do you think of that string?? Is there a way to modify the string??

Thanks Again