Sort Via Checkbox reult

[dale_j1992]

Hello i have a little problem i am hoping someone can help me with. I am trying to sort using a query, i want to show all records with a checkbox checked first in Date Order, followed by records with checkbox unchecked second i n Date order. Any help is greatly appreciated. Kind regards

 

[pbaldy]

In the query, sort by both fields. The order in which the fields appear determines the priority of the sort, left to right, so you want the checkbox field before the date field.

 

[dale_j1992]

Many thanks that worked perfectly, i was not aware of the left to right corresponding to order.

 

[pbaldy]

Happy to help!