MS Access in query: The expression you entered contains invalid-syntax

user_13482432 0
Viewed 358

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: enter image description here

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.

ms-access syntax database
1 Answers

Most likely, your local separator is semicolon:

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