Date fields in query (1 Viewer)

Hi All.

I'm going numb on this. Sound's silly but I'm stuck.

I need to fetch records from a table using a query.A file moves from one officer to another and I track it using Access 2010. My query is as

select file_no,file_name,off1_datein,off1_dateout,off2_datein,off2_dateout,....
from filetrack
where ( condition should be cleared by officer1 but not by officer2 )

This could extend to (cleared by officer1, cleared by officer2, but not by officer3)
etc.

I get too complex to evaluate error message. And does notnull, isempty etc work on dates ?

Please help soon.:banghead:

You aren't storing those movement in a normalized fashion, one movement should be one record. You will find querying and reporting on your current structure a nightmare.

If it helps in a query you would normally use [Your Field] Is Null in the where clause not IsNull()

Thanks a lot.