How about modifying your membership table to include a Yes/No field for ActiveMember. That way, you can just flip a switch on the member rather than worry about moving records. Perhaps you should also add a field for tracking the date that they went inactive, so if they have not re-activated themselves for several years, you can just archive them away.
Dawn Crosier Application Specialist Microsoft MVP "Education Lasts a Lifetime" This message was posted to a newsgroup. Please post replies and questions to the group so that others can learn as well. -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hassan Sent: Friday, September 09, 2005 1:14 PM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Move Expired members to another table Hi All, I have this membership access database that i am working with and i am having some problems that i need your help with. First let me explain my database to you guys, this is a membership database and membership is an year long only. What I would like to do is to move the expired members to an another table. Since membership is year long only after each year i want the memebers to move to another table if they dont want to continue the membership and in the future if they want to renew it i can just simply move them back to the main table. is that possible?? Any help would be nice. thanks alot here is my database http://www.megaupload.com/?d=40CLA7QM its 89kb. ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
