Fix Microsoft Access Parameter Queries That Fail for Date Criteria
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.
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.
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.
Open the form in Design view and add two text boxes named txtStartDate and txtEndDate, or open an existing reporting form that contains them.
In the Access navigation pane, right-click the parameter query and choose Design View.
In the date field criteria row, enter: Between Forms!frmReport!txtStartDate And Forms!frmReport!txtEndDate.
On the Query Design tab, click Parameters, enter Forms!frmReport!txtStartDate and Forms!frmReport!txtEndDate, and set each Data Type to Date/Time.
Click Run to test the query and confirm the expected date range records are returned.

Rename a Field Called Date to Avoid Reserved Word Conflicts
Use this if the date field is named Date, because Date is a reserved word and can confuse the Access query engine.
Correct Date Criteria Syntax and Remove Extra # Delimiters
Use this when Access shows an invalid date value error or returns no records because # signs were placed around parameters.
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.

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.




