inactive records

  • Thread starter Thread starter VATheresa
  • Start date Start date
V

VATheresa

i need to inactivate records and do not want to delete them. is there a way
to do this without creating a new field?
 
It all depends on how you identify that they're inactive.

More details are needed...
 
You want Access to "know" that a particular record is "inactive", but you
don't want to store that information in a field that Access can see/use?

I don't know of a way to do that unless you add a field ... (or maybe, add a
totally new table that stores the ID of the row that's been inactivated ...
but that's more work than just adding a field!)

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Is there something in the current data that would make it obvious that the
records are inactive like a Date field or something like a Status field? If
so you could write a query to exclude those records.

If not, you probably need a Yes/No field named something like Inactive with
the default being No.
 
Back
Top