Ms Access in Query: the Expression You Entered Contains Invalid-Syntax

Sophia Al-Mansoor
Sophia Al-Mansoor
• • 1 min read

I Have This Error Message: You Omitted a Operand or Operator, You Entered an Invalid Character or Comma, or You Entered Text Without Surrounding It in...

Ms Access in Query: the Expression You Entered Contains Invalid-Syntax

I have this error message: You omitted a operand or operator, you entered an invalid character or comma, or you entered text without surrounding it in quotation marks.

Here is a picture about my problem:

I want to format my "BYDAY" query and they have a problem with this: BYDAY: Format([SDÁTUM],"ddd") and i got this error message.

1 Answer

Most likely, your local separator is semicolon:

BYDAY: Format([SDÁTUM];"ddd")
0

Must Read

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Sophia Al-Mansoor

Sophia Al-Mansoor

Global Business & E-Commerce Reporter
Linkedin Twitter

Sophia analyzes international trade, startup ecosystems, retail transformation, and supply chain logistics for modern digital publications.

Share this article
Twitter Facebook Pinterest