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").
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Parameters 1
Create a record on current mont 1
Sorting by the present (or a subsequent) month 9
Hiding records 2
Query to Average data based on date from another table 1
Open form in edit mode to add contents - but open by user last name 1
identify employees that have/haven't taken certain training course 2
Date Query 1

Back
Top