De-activating a record

[Guest]

I have a database of contractractors that we use. within this database are
some records that are not used very often (if at all)and when i mail merge i
end up with a lot of contractors that i do not want. i can not delete the
records as they are still needed. Is there a way that i can de-activate them
so that they are still there but are omitted from my mail merge. I am
working in Access 2000

 

[Guest]

I assume the source for you mail merge is from a table within the database.
Base your mail merge on a query instead and put criteria in this query that
will filter out the records that you don't want.

 

[Guest]

Add a Date field to the table. The date is the date the contractor went
inactive. Base all queries for your forms on this date. with