This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 69%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
I had used the advanced filter on a regular basis on multiple tables at a time, why was it changed from a filter to a query. Are there any plans to change it back to an actual filter? This has been extremely frustrating. The query doesn't work well since it causes a visual issue to look at the data.
A family of Microsoft relational database management systems designed for ease of use.
Answer accepted by question author
Hi,
I reported the problem to the Microsoft Access team. They identified it as a current bug that will be fixed soon. Meanwhile the workaround to get the normal filter functionality is to disable Monaco:
File > Options > Current Database > Uncheck the box at Enable Monaco SQL Editor
Servus
Karl
Karl, thank you - this is a great work around and am thrilled that I am able to utilize the Advanced Filter as it was meant to be used.
We have been informed by Microsoft that a change was made to address this problem for Current Channel.
If you are in Current Channel, you only have to restart Access and the problem should be resolved.
If you are in CC, you only have to restart Access and the problem should be resolved.
Your description is sufficiently vague that it is not clear what exactly your concern is, especially, "...it causes a visual issue to look at the data."
Please, to help us understand your concern, post some screenshots of what you see and what it is that bothers you.
Hi George,
Since this is not the first report I read about this, I had a look and can confirm that there's a change in version 2510:
Since ever and until 2509 when you chose Advanced Filter/Sort from the ribbon the ribbon stayed at the Home tab and you could simply toggle the filter in datasheet view.
Now in 2510 you get the query ribbon and have to create and execute a query, which then isn't available as a simple filter.
I'm going to ask the Microsoft Access team if they are aware of this.
Servus
Karl
Access Forever, News, DevCon
Access-Entwickler-Konferenz AEK
What I mean is now you basically have to view 2 tables - the original table and the query/filter table when prior I only viewed the original table when the advance filter was used
AI answer
The context does not provide any information regarding plans to change the Advanced Filter back to a traditional filter or the reasoning behind its current implementation as a query. It mentions that the Advanced Filter API enables complex cross-visual data-point selection and filtering queries based on multiple criteria, but does not address user feedback or future changes to this functionality.
If you have concerns or feedback regarding the Advanced Filter, it may be beneficial to reach out to Microsoft support or check their official channels for any updates or announcements related to this feature.
References: