Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    May 2002
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Savings Records to Another File (2000/sp1a)

    I am responsible for maintaining a fairly large membership database. Each month I need to produce mailing labels. Some memberships expire each month and I delete them from the database before running the labels. Of course later that month a number of those folks finally get around to renewing their memberships and I have to re-enter all data again. Is there a way to just move, cut, etc each months expirations into another database/file and when I might need them just move, cut, etc them back to my main membership database? Thanks for any help. Ken

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Savings Records to Another File (2000/sp1a)

    Don't delete those records.
    Add a yes/no field to your table and use this to mark the member active or non-active.
    In the the mailing label report or in the underlaying query set a filter to print only the active member.
    Additionaly, you could add a field with the date that the member becomes non-active, and delete them if the are not renewing membership after some weeks or months.
    Francois

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Savings Records to Another File (2000/sp1a)

    Ken - you must have something in the database to indicate the expiration of memberships already - otherwise you wouldn't know when to delete those non-renewals (and send out the reminders in advance, etc). Just include a criterion in your label-printing routine that "LapseDate >= Date()." If you only know that someone's membership is expiring because you have a start date and a term then the expression has to change a bit, but not the underlying idea. Then when they renew, you just have to update your expiry date (or start date + term data)

  4. #4
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Blacktown, Sydney, New South Wales, Australia
    Posts
    175
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Savings Records to Another File (2000/sp1a)

    Have had a similar problem. However I had a number of fields such as:
    Active?
    e-mail?
    SnailMail?
    SpecialMailOut?

    All of which were Yes/No fields.

    This enabled me to use filters/queries to create Labels and/or Mail Merge documents using a combination of the fields.

    Only difference is my queries are make table or append type and I create letters and labels from MS Word (more flexability), and use Access database as data source.


    HTH

    Addendum
    By the way, don't forget that Active = No, can be useful to send out reminders of lapsed membership

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •