Others

Fix Microsoft Access Parameter Queries That Fail for Date Criteria

John WilsonJohn Wilson Nov 13, 2026 869 views

Question details

The user needs to fix Microsoft Access date parameter queries that return no records because parameters are not declared, criteria syntax is incorrect, or a field is named Date, which is a reserved word.

Product
Microsoft Access
Device & OS
not provided
Scenario
The user is building or editing an Access query that filters records by date parameters and expects it to return the matching records.
Observed behavior
The query returns no records or shows an invalid date value error when date criteria are used, especially with undeclared parameters or a reserved field named Date.
Before you start

Open the Access query in Design view and check the date field name and the criteria row. Note whether the date field is named Date and whether any date parameters are declared.

Solution 1Recommended

Use a Form and Declare Date/Time Parameters in Access

Use this when the query is run from a form or when you need reliable date input without embedding literal dates in the criteria.

Referencing form controls keeps date entry centralized and avoids delimiter mistakes. Declaring parameters tells Access how to treat the values.

1
Create date input controls on a form

Open the form in Design view and add two text boxes named txtStartDate and txtEndDate, or open an existing reporting form that contains them.

2
Open the query in Design view

In the Access navigation pane, right-click the parameter query and choose Design View.

3
Reference the form controls in the criteria row

In the date field criteria row, enter: Between Forms!frmReport!txtStartDate And Forms!frmReport!txtEndDate.

4
Declare both parameters as Date/Time

On the Query Design tab, click Parameters, enter Forms!frmReport!txtStartDate and Forms!frmReport!txtEndDate, and set each Data Type to Date/Time.

5
Run and verify the query

Click Run to test the query and confirm the expected date range records are returned.

Use a Form and Declare Date/Time Parameters in Access
Dates are handled correctly: Declaring the parameters prevents Access from treating them as text and avoids invalid date value errors.
Free Microsoft Office alternative

Switch to WPS Office for Everyday Office Files When Access Queries Are Not Required

WPS Office is a free, lightweight office suite that opens and edits Microsoft Word, Excel, and PowerPoint files with a familiar ribbon interface. While it does not replace Microsoft Access for database queries, it offers seamless migration for documents, spreadsheets, and presentations without subscription costs.

Familiar ribbon-style interface reduces the learning curve when switching from Microsoft Office.Opens and saves Microsoft Word, Excel, and PowerPoint files with high format compatibility.Free and lightweight installation for everyday documents, spreadsheets, and presentations.Seamless migration for reports and data work that can be handled in WPS Spreadsheet.
QA img-9

Frequently Asked Questions

Why does my Access date parameter query return no records?

The usual causes are undeclared parameters, incorrect date criteria syntax, or a field named Date. Open the query in Design view, click Parameters and set each date parameter to Date/Time, and rename any Date field to OrderDate or AppointmentDate.

How do I use form controls as date parameters in Access?

Add text boxes such as txtStartDate and txtEndDate to a form, then set the query criteria to: Between Forms!frmReport!txtStartDate And Forms!frmReport!txtEndDate. Declare both controls as Date/Time in the Parameters dialog.

Should I put # signs around Access date parameters?

No. Do not add # around a parameter that already represents a date expression, such as [StartDate]. Use # only around literal date values, for example #2024-01-01#.

Can I keep a field named Date in an Access table?

It is not recommended because Date is a reserved word and can cause query conflicts. Rename the field to OrderDate or AppointmentDate in table Design view, then update the query.

Can WPS Office open or run Microsoft Access queries?

No. WPS Office does not include an Access database application, so it cannot run Access queries. It provides Writer, Spreadsheet, and Presentation as free alternatives for Word, Excel, and PowerPoint files.