I changed the criteria and that didn't work...it still shows all the entries, checked and no,t on the report. As for the reply from healdem...I don't really know much about the VB aspect....that was very confusing to me, but I appreciate the attempt.
Maybe if I break it down more.
I have a table which is populated by people entering the data into a simple form (named DA File Request Entry) which asks for - Last Name, First Name, Date, Docket #, Officer.
I created another form (named Completed Requests) that the person who actually pulls the files can go into to mark them as completed.
I have a two queries, one(Files Needed) that pulls the entry and another Completed File Tracker) which shows the completed entries. The report is for the person who has to retrieve the files. I want the report to only show the files that have not been retrieved yet. It currently shows all the files. The ones that are checked and the ones that are not. Over time this report will become huge which is why I only want the incomplete ones to show.