I have a table with a job list. When the job is assigned, I want it to no longer appear in my query. I tried using a date assigned and date vacated. If both dates were null, it would show the listing. If it was assigned, it would not show. If the job was vacated, both dates would be listed and it would show again. The problem comes when I assign it again. It will still show because the new record doesn't appear, but the previous record with both dates would appear. I know there is a better way to to do this. I'm open to suggestions.