criteria for filtering check boxes in a query

[Guest]

I am trying to do a permanent sort for columns using check boxes. I need to
know the formula for the criteria box

 

[fredg]

I am trying to do a permanent sort for columns using check boxes. I need to
know the formula for the criteria box

What is "a permanent sort for columns using check boxes".

Perhaps your terminology is clear to you, but I think you would do
well to re-think and repost your question.

 

[Guest]

What is "a permanent sort for columns using check boxes".

Perhaps your terminology is clear to you, but I think you would do
well to re-think and repost your question.

When I say permanent sort I mean when I do a filter in the main window and
save the query and reopen it, the filter is not saved. When you enter in
criteria (formula) in design view and save it is saved with only the filtered
names that is what I need

 

[fredg]

When I say permanent sort I mean when I do a filter in the main window and
save the query and reopen it, the filter is not saved. When you enter in
criteria (formula) in design view and save it is saved with only the filtered
names that is what I need

OK.
A filter is not a sort.
A check box has a value of either -1 (if checked) or 0 (if unchecked).
So, in query design view, as criteria on the check box column, write
-1
to show just the records that are checked.
or
0
to show just the records that are not checked.

If you wish the user to select either checked or unchecked then as
criteria on the check box column, write:
[Enter -1 for checked or 0 for unchecked]

When prompted, if the user enters -1 only checked records appear.
If the user enters 0 only unchecked records appear.

Is this what you are looking for?