I have a query that pulls maintenance items for an individual asset, and one of the fields in the query is a Yes/No value. This field lets the client designate the maintenance item as Needed. The client wanted this so that when they complete the work, they can uncheck the box.
Unchecking the box removes it from the list of outstanding maintenance items on a given asset, but it keeps the maintenance item in the table so that the client can have a history of work requested and work performed. Tracking the outstanding work separately helps them to budget their maintenance monies.
When I execute the query, I want the checked (Needed) values to bubble to the top of the query results. I've tried ascending/descending sorts, but they still mix the checked/unchecked items together. Is there a way to do this, or is it better to group by the items Needed status?
Many thanks for your consideration.
Unchecking the box removes it from the list of outstanding maintenance items on a given asset, but it keeps the maintenance item in the table so that the client can have a history of work requested and work performed. Tracking the outstanding work separately helps them to budget their maintenance monies.
When I execute the query, I want the checked (Needed) values to bubble to the top of the query results. I've tried ascending/descending sorts, but they still mix the checked/unchecked items together. Is there a way to do this, or is it better to group by the items Needed status?
Many thanks for your consideration.
