Others

How to Fix Microsoft Access Less Than/Greater Than Filter Issues

Maira Mehtab Sep 22, 2026 868 views

Question details

Users experience confusing behavior where 'Less Than' or 'Greater Than' number filters in Microsoft Access appear to include the boundary value instead of strictly excluding it.

Product: Microsoft Access for Microsoft 365
Device & OS: not provided
Scenario: Applying context-menu number filters to datasets where strict less than or greater than logic is expected.
Observed behavior: The context-menu wording says 'Less Than' or 'Greater Than', but the underlying filter logic acts as 'less-than-or-equal-to' or 'greater-than-or-equal-to', including the entered boundary value.

Before you start

Verify your current Microsoft Access version and test your number filters on a small sample dataset to confirm the exact comparison behavior before applying it to your main database.

Solution 1Recommended

Use Explicit Query Criteria Instead of Context Menu Filters

Bypass the confusing context-menu wording by manually defining the exact comparison operator in the query design view.

Since the default context menu may mislabel the underlying filter logic, manually typing your criteria ensures that the database processes the exact mathematical comparison you intend.

Open Query Design

Open your database and switch to the Query Design view for the specific table you want to filter.

Enter Strict Criteria

In the Criteria row under your target number field, manually type the exact mathematical operator (for example, < 50 or > 100).

Run and Verify

Click 'Run' to execute the query and verify that the results strictly exclude the boundary value as intended.

Solution 2

Check Dialog Labels and Report to Microsoft

Since the filter dialog box shows the correct logic despite the context menu's incorrect label, verify the dialog and submit feedback to Microsoft.

Free Microsoft Office alternative

Try WPS Office for Your Data Processing Needs

While Microsoft Access is built for complex relational databases, many everyday data management and filtering tasks can be efficiently performed using spreadsheets. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for your daily data processing, document creation, and presentation needs.

1. Download WPS Office: Visit the official WPS website and click the free download button.
2. Install the Software: Run the downloaded installer and follow the simple on-screen instructions to complete the setup.
3. Manage Your Data: Launch WPS Spreadsheet to open your exported data files, applying accurate number filters effortlessly.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Powerful spreadsheet functions for filtering, sorting, and analyzing large datasets without complex database queries.Free and lightweight, ensuring smooth performance and fast installation even on older devices.Familiar user interface for a seamless migration from Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my 'Less Than' filter include the exact number I typed?

In some versions of Microsoft Access for Microsoft 365, the context menu label says 'Less Than', but the underlying filter logic actually applies 'less-than-or-equal-to'. Always check the filter dialog for the exact wording.

How can I ensure my Access filter strictly excludes the boundary value?

Instead of using the default context-menu Number Filters, open the Query Design view and manually type the strict < or > operator in the Criteria row.

Is this filter behavior a bug in Microsoft Access?

It is generally considered a wording inconsistency in the context menu rather than a core logic failure, as the specific filter dialog box usually displays the correct 'less than or equal to' text. Microsoft has been notified, and users are encouraged to report it via the Help > Feedback tool.

Office Quick Solutions