Purging a record from a Query, but not linked table

  • Thread starter Thread starter GC
  • Start date Start date
G

GC

I've set up a db that contains information about
employees. Ex: Hire Date, Termination Date, Etc. I've
built a query off that table that pulls all employees
marked as Terminated.

I am in the process of creating a field in that query with
a selection titled "Completed Termination"

What NEXT

After marking Field in Query as "Completed Termination"
I want that record purged from Query, but not the table.
Is this possible?
 
?Purged from Query? Do you mean you don't want to see it when you run the
query to find those suitable for termination?

If so, just add the criterion to the query that indicates "WHERE Terminated
= False" (pseudo-code, since you didn't indicate what form your data takes
when you indicated "terminated").
 
Back
Top