Using Filters

  • Thread starter Thread starter DMims
  • Start date Start date
D

DMims

I have a data base that I use to track my current clients, but when they are
no longer my clients or the contract ends how can I move them to the Former
table that I have set up by using the filter system? Can this be permanet
change?
 
The easiest way would be to insert a new field into your contacts table
called Former. Set it to text, 1 space.

When the contact becomes a "Former", place an "X" in the field.

Create an append query which will add the former contact to your former table.

Create a delete query which will delete the Formers with an X

MAKE SURE YOU DO THIS IN THE RIGHT ORDER.

You can create a macro to automate this function.
 
Thank you for the response, now I have never created a macro. Is this a
simple function that will just look into the table and remove the former
clients? Thanks for all of the help
 
Back
Top