How to sort boolean field MS Access

I am trying to display data in a combobox on a form so that I can see the data sorted. see image 1
I would like to be able to do a sort on the boolean fields first so that the false fields are at the top and the true at the bottom.
I would then like to sort on the job name within the boolean field groups of true and false.
I can sort the data on the job name but it doesnt seem to work for the boolean fields.
How would I do this?
Who is Participating?
peter57rConnect With a Mentor Commented:
This is sorting by ID first and then jobComplete;
just edit line 3 of the sql to ....
ORDER BY tbl_jobName.jobComplete, tbl_jobName.ID ;
What is the rowsource of the combobox (sql view please)?
funkimunkyAuthor Commented:
The SQL code is below
SELECT tbl_jobName.ID, tbl_jobName.jobName, tbl_jobName.jobDescription, tbl_StaffMember.KnownAs, tbl_jobName.jobComplete
FROM tbl_StaffMember INNER JOIN tbl_jobName ON tbl_StaffMember.ID = tbl_jobName.jobOwnedBy
ORDER BY tbl_jobName.ID, tbl_jobName.jobComplete;

Open in new window

funkimunkyAuthor Commented:
I cant believe it was that simple, points well deserved.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.