Queries And Reports

It's been a long time since I have worked with Access. Here is what I did and what I am trying to do. I'm basically at wits end.

I created a table which consists of fields that contain data pertaining to project management. The Engineering manager wants to be able to do reports on the different projects based on what steps of the project has been finished and who it was assigned to.

Here is an example.

Step 2

Heat Transfer complete? Yes/No drop down box
Step Assigned to: Employee drop down box
Date Completed? Date/time field
Commments: A field for text that pertains to the step if there was a promlem etc etc.

As it stands right now there is a total of 12 steps with each step ranging from 1 to 6 questions like the above example.

For the first report he wants me to create, I need to the following data (which I have the query pulling from my table) Project #, Customer, Engine Make, Engine Model, and the first step where any task is marked at No, and the person assigned to the task that is marked no, the step comments, and he wants is sorted by step.

I have all the data fields from the table included in the query as the way I understand it, the query needs to run through each record, and stop when it finds the first no answer for a step and report it for each record. My problem is, I have no idea on how to accomplish this. Anyone have any ideas?