Hype Blast

Home / updates

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

Olivia Carter |

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.

1 Answer

Most likely, your local separator is semicolon:

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

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

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.

You Might Also Like