I need to create some filters on my Access form and need some help. I have done a ton of research and due to my experience being little, I need some help with this.
I want to create a Combo Box on a form that will apply a filter to view a selection of records.
One of the fields on the form is called MCC. I want to view records that do not contain the following MCC codes: 07011, 07012, 04522, 04511, 03000
So basically, I want to show only records that do not have one of these MCC codes.
Any help with this is greatly appreciated.
I want to create a Combo Box on a form that will apply a filter to view a selection of records.
One of the fields on the form is called MCC. I want to view records that do not contain the following MCC codes: 07011, 07012, 04522, 04511, 03000
So basically, I want to show only records that do not have one of these MCC codes.
Any help with this is greatly appreciated.