Hi hassan , This is rochrgi(Romy) a pilipino your idea is good but u can do it automatic i will just give u an idea an u can do it i know. add a new field to that will monitor the date of member ship if not expired the it true else it not true so when member reactivated the tag or monitoring field will be false. OK Bye and thanks. Best Regards, Romy
Hassan <[EMAIL PROTECTED]> wrote: 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. SPONSORED LINKS Microsoft access database Microsoft access Microsoft access database design Microsoft access database training --------------------------------- YAHOO! GROUPS LINKS Visit your group "AccessVBACentral" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Click here to donate to the Hurricane Katrina relief effort. [Non-text portions of this message have been removed] ------------------------ 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 --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> 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/
