Forum Discussion
eddypi123
Jan 08, 2025Copper Contributor
Bug in Microsoft Access's Number Filters for Less Than & Greater Than options
Dear Microsoft Office 365 Development Team,
I am submitting this bug report regarding an issue I have encountered with the Number Filters in Microsoft Access within Office 365. Specifically, the "Less Than..." and "Greater Than..." filters do not behave according to basic mathematical principles.
Here are the details of the issue:
- When applying the "Less Than..." filter and entering a value (e.g., 250), the filter includes records equal to 250 in the result. The correct behavior should be to display records with values strictly less than 250, i.e., from 1 to 249.
- Similarly, when applying the "Greater Than..." filter and entering a value (e.g., 250), the filter also includes records equal to 250. The expected behavior should be to show records with values strictly greater than 250, i.e., from 251 to 500.
It appears that the filter logic is not following the expected mathematical rules for "less than" and "greater than" comparisons.
Could you kindly investigate this issue and confirm once a fix is available? I would also appreciate it if you could provide details about when the new, fixed version of Microsoft Access will be released.
Thank you for your attention to this matter.
Kind regards,
It is not a bug, only truncated menu entries in the tiny second level popup menu. Everywhere else - the first level popup menu, in the band, when you are selecting these entries, and when opening Advanced Filtering - "Greater/Less than or equal" is stated.
So, it is a UI flaw. I've reported this.
- Gustav_BrockIron Contributor
It is not a bug, only truncated menu entries in the tiny second level popup menu. Everywhere else - the first level popup menu, in the band, when you are selecting these entries, and when opening Advanced Filtering - "Greater/Less than or equal" is stated.
So, it is a UI flaw. I've reported this.