Others

How to Fix Date Syntax Errors in Microsoft Access Query Expressions

Camila MilosovichCamila Milosovich Nov 13, 2026 871 views

Question details

The user needs to resolve date syntax errors in Microsoft Access query expressions and determine the correct way to store, display, and query the FD_Date field.

How to Fix Date Syntax Errors in Microsoft Access Query Expressions
Product
Microsoft Access
Device & OS
not provided
Scenario
The user maintains an Access form with an unbound combo box set to Now() on load and appends daily dates to a Food_Distribution table using the regional DD.MM.YYYY format.
Observed behavior
Access returns date syntax errors or produces incorrect criteria results when FD_Date is stored as text or queried using regional date text values.
Before you start

Open the Access database, open the Food_Distribution table in Design View, and confirm whether FD_Date uses the Date/Time data type or Text. Also check the Windows regional date format so you can match query criteria and display formats intentionally.

Solution 1Recommended

Store FD_Date as a Date/Time Field and Remove Text Delimiters from Date Criteria

Use this solution when your query criteria treat dates as text or when the FD_Date field is currently stored as Text, because the Date/Time type prevents most regional date syntax errors and keeps sorting reliable.

Access evaluates Date/Time fields by their underlying numeric value. The regional date format is only a display format, so you can keep DD.MM.YYYY on screen without storing the date as text.

1
Open the table in Design View

In the Access Navigation Pane, right-click the Food_Distribution table and select Design View.

2
Change the FD_Date data type

Click the Data Type column for FD_Date, choose Date/Time, and save the table. If Access prompts to convert existing text, first correct any invalid date text in the table.

3
Update the query criteria

In Query Design View, click the Criteria row under FD_Date and use the query date picker or type an Access date literal that matches your Access locale, such as #2/1/2025# for U.S. settings. Avoid quoted text like '01.02.2025'.

4
Run and verify sorting

Click Run on the Query Tools Design tab and confirm the records appear in chronological order rather than alphabetical order.

Store FD_Date as a Date/Time Field and Remove Text Delimiters from Date Criteria
Date criteria now use the correct data type: After FD_Date is changed to Date/Time, Access compares the value as a date, which removes many date syntax errors caused by text delimiters and regional text values.
Free Microsoft Office alternative

Move Access Data Tasks to WPS Office for Everyday Spreadsheets and Reports

WPS Office is not an Access database replacement, but it is a free and lightweight Office alternative that helps you work with exported Access data, documents, and reports in a familiar ribbon interface with high compatibility for Microsoft Excel, Word, and PowerPoint files.

  1. 1. Export Access data to Excel: In Microsoft Access, select the table or query, click External Data, and choose Export to Excel to create an .xlsx file.
  2. 2. Open the exported file in WPS Spreadsheets: Launch WPS Office, click Menu > Open, and select the exported .xlsx workbook to review or summarize the data.
  3. 3. Create or edit related documents: Open Word-compatible reports or PowerPoint presentations in WPS Writer or WPS Presentation and continue using the familiar ribbon tools.
  4. 4. Save in Microsoft-compatible formats: Use Menu > Save As to keep .xlsx, .docx, or .pptx formats for teammates who still use Microsoft Office.
Avoid recurring Access query syntax issues by exporting your data and handling daily reporting in WPS Spreadsheets.Open and edit exported Access data in WPS Spreadsheets with full Microsoft Excel .xlsx compatibility.Free to download and lightweight, with a familiar interface that makes migration from Microsoft Office smooth.Work with exported Access data in WPS Office without managing complex query expression delimiters.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Access show a date syntax error when I enter DD.MM.YYYY in query criteria?

Access treats DD.MM.YYYY as text unless the field is Date/Time and the literal is correctly delimited. Store the field as Date/Time, then use the query date picker or an Access date literal appropriate for your Access locale. Avoid plain quoted text like '01.02.2025'.

Should I store FD_Date as text to keep the DD.MM.YYYY format?

No. Store FD_Date as a Date/Time field. Set the control Format property to dd.mm.yyyy for display, and use the Windows regional format for any other application. Text dates cause string sorting and criteria errors.

How do I stop an unbound combo box from automatically setting Now() when the form opens?

Open the form in Design View, select the combo box, open the Property Sheet, and check the Form Load event. Remove or change the line that assigns Now() to the unbound combo box unless it is bound to a Date/Time field and you truly need a default value.

Can WPS Office open .accdb or .mdb Access database files?

No, WPS Office is an alternative for spreadsheets, documents, and presentations. Export the Access query or table to an Excel .xlsx file, then open it in WPS Spreadsheets. You still need Microsoft Access for the database application and its query engine.