Multiple yes/no boxes

[Guest]

I have a table that tracks steps completed in a project. The steps are setup
as yes/no boxes. I am trying to write a querry the will bring back the
current step in progress.
For example, there are boxes for pursuit, purchase, construction, close, etc.
When I run the report, I want only the last checked field to display. So if
there are checks in pursuit, purchase and construction. I would like the
report to display construction.
Thank you

 

[Guest]

There are much better ways than using checkboxes to keep track of your stuff.
You could use a one-to-many relation between project and status. In the
status table also have TransDate, Notes, Employee, etc.
Or you could use an option group in a form to select the status.

But this might do what you want ---
SELECT rsmith.xx,
IIf([close]=-1,"Close",IIf([construction]=-1,"Construction",IIf([purchase]=-1,"Purchase",IIf([pursuit]=-1,"Pursuit","Error")))) AS Status
FROM rsmith;

Substitute your table and field names in the query.