funkimunky
asked on
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?
trueFalse.jpg
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?
trueFalse.jpg
What is the rowsource of the combobox (sql view please)?
ASKER
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;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I cant believe it was that simple, points well deserved.