criteria for filtering check boxes in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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.
 
fredg said:
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.
Click to expand...
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
 
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
Click to expand...

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?
 
Back
Top