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 <*> 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/