I have a table that has a regular yes/no field. Some of them are yes some of them are no. When I click the little funnel at the top to filter I can select yes, no, or all. I click yes and it shows me all the yes records. I click no and it shows me nothing. I click the filter again and see that my check mark was taken out. I make a query out of the table and it does the same thing. I have another yes no field that I made a while back in the table and it works just fine. Iv delete and remade the problem field several times and im at a loss. Iv never seen this before.
Table filtering question
- Thread starter zgray
- Start date
I have a similar problem. My DB has several tables and for most of the fields, the filtering works fine, including clearing the filter and re-filtering options. However there are several fields for which it doesn't work properly. e.g. refer to the attached images:
pre filtering.jpg - I filter the field for one value on the list. It filters OK, but
post filtering.jpg - all other values are removed from the checkbox list, the and the "Clear filter" option is not available and the funnel icon is not present in the title bar.
I've compared configurations for all the ones that don't work properly with each other and with some that do. There are no settings unique to the problem.
Also, I cannot see any relevant settings in the File>Options menu.
Does anyone have any tips?
Thanks
pre filtering.jpg - I filter the field for one value on the list. It filters OK, but
post filtering.jpg - all other values are removed from the checkbox list, the and the "Clear filter" option is not available and the funnel icon is not present in the title bar.
I've compared configurations for all the ones that don't work properly with each other and with some that do. There are no settings unique to the problem.
Also, I cannot see any relevant settings in the File>Options menu.
Does anyone have any tips?
Thanks
Attachments
Similar threads
