Sorting by boolean fields (1 Viewer)

[habiler]

Hi all of you,

That's my problem

I have 3 fields Yes/No.

A B C

To be in order it is necessary that: A , B and C = Yes.
I would want to print all differents combinations :

A = no et B et C = Yes
Then

A: Missing

Nom, prenom et adresse.
.....
.....

A = Yes, B=No and C = No
Then

B and C missing :
Nom, prenom et adresse.
......
.......

Etc.....
Thanks for all

Habiler

 

[MarkK]

A boolean value is a number where True = -1 and False = 0. So sort away. If you sort ascending, -1 < 0, so True will sort first, which is what you want, I think. In a query, use an ORDER BY clause like . . .

ORDER BY A, B, C

. . . and ascending is the default.
Hope this helps,