Hi,
I have a report that includes buttons to filter the information displayed. One set of buttons filters by type (using the SetFilter embedded macro) and another set of buttons filters by location.
However, when I set one filter it clears any previous filters. So if I filter by location (using the button and macro) and then filter by type (again, using a button and macro) the location filter is ignored. So I am only able to apply one filter at a time to the entire data set.
What am I doing wrong? The report record source is a query. I would like to be able to apply multiple filters to the infromation. Any suggestions?
Thank you, I appreciate any advise or suggestions to help me solve this problem.
I have a report that includes buttons to filter the information displayed. One set of buttons filters by type (using the SetFilter embedded macro) and another set of buttons filters by location.
However, when I set one filter it clears any previous filters. So if I filter by location (using the button and macro) and then filter by type (again, using a button and macro) the location filter is ignored. So I am only able to apply one filter at a time to the entire data set.
What am I doing wrong? The report record source is a query. I would like to be able to apply multiple filters to the infromation. Any suggestions?
Thank you, I appreciate any advise or suggestions to help me solve this problem.
Last edited: