Others

Fix Microsoft Access Date Criteria Returning Out-of-Range Records

Rana GarciaRana Garcia Nov 14, 2026 869 views

Question details

The user needs a Microsoft Access parameter query to return records within a requested date range.

Fix Microsoft Access Date Criteria Returning Out-of-Range Records
Product
Microsoft Access
Device & OS
not provided
Scenario
A query prompts for start and end dates to filter the Recruiter Interview Date field.
Observed behavior
The query returns records outside the requested range, even after date-range criteria were tried.
Before you start

Open the query in Design View and locate the Recruiter Interview Date field and its Criteria row. Check whether the field contains time values as well as dates.

Solution 1Recommended

Correct the date boundaries and parameter types

Use this method to check the query criteria and ensure Access treats both prompts as dates.

1
Set both boundaries

In the query's Design View, enter >= [Enter the start date] And <= [Enter the end date] in the Criteria row under Recruiter Interview Date. Alternatively, enter Between [Enter the start date] And [Enter the end date].

2
Declare the parameters

On the Query Design tab, select Parameters. Enter [Enter the start date] and [Enter the end date] exactly as they appear in the criteria, and set each data type to Date/Time.

3
Check other criteria rows

Inspect the Criteria and Or rows in Design View. Criteria on separate rows are joined with OR and can allow records that do not meet the date range; adjust the rows to match the intended logic.

4
Run the query

Select Run and enter a start date and an end date. Compare the returned interview dates with both boundaries.

Correct the date boundaries and parameter types
If dates include times: An end date entered without a time represents midnight, so <= may exclude records later that day. For date-only prompts, use >= [Enter the start date] And < DateAdd("d", 1, [Enter the end date]) to include the entire end date.
Free Microsoft Office alternative

Review Exported Access Data in WPS Spreadsheets

WPS Office is a free, lightweight alternative for everyday office work, with a familiar interface and Microsoft Office format compatibility. Export Access results to an Excel workbook to review them in WPS Spreadsheets; WPS does not repair Access queries.

Review exported interview dates in a familiar spreadsheet interfaceOpen and edit Microsoft Excel XLSX filesWork with common Microsoft Office document formats for easier migrationUse a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Does Between include the start and end dates in Access?

Yes. Between includes both boundary values. However, if the end date is entered at midnight, records with a later time on that date are not included.

Why do I still see dates outside the range after correcting the criteria?

In Query Design View, check for conditions on an Or row, which can admit additional records. Also check that the source field and both query parameters use the Date/Time data type.

How can I include every time on the end date?

For date-only prompts, use >= [Enter the start date] And < DateAdd("d", 1, [Enter the end date]) in the date field's Criteria row.

Where do I set the query prompt data types?

Open the query in Design View, select Parameters on the Query Design tab, and add each prompt with the Date/Time data type. The names must match the prompts in the criteria.