Sort query by checkbox

Question

Below is the SQL for my query. Is there any way to sort this so that the checkbox cleared is not checked it will sort to the top?

SELECT tblMissingCards.MissingCardID, tblMissingCards.EmpID, tblMissingCards.Cleared, tblMissingCards.MissingDates, tblMissingCards.ReasonID, tblMissingCards.SubmittedDate, tblMissingCards.SubmittedBy

FROM tblMissingCards

WHERE (((tblMissingCards.EmpID)=[Forms]![frmNavigationForm].[NavigationSubform].[Form]![cboSearchName]))

ORDER BY tblMissingCards.Cleared;

Answer 1

If a check box is ticked, its value is True = -1. If it is clear, its value is False = 0. To sort the False values before the True values, you must sort descending:

...

ORDER BY tblMissingCards.Cleared DESC;