the expression you entered contain invalid syntax in access query

0
votes

I am trying to make a query. I don't type anything. I use only every formula by clicking in built-in function of access, but I get this popup error

enter image description here

1
ms-access
You have incorrect quotation blocks. Please past the code into your code as well as the image. Trimming the image down and showing it in your post would also be a nice touch. – user6432984
Hi&Thanks IdKioskEjraN: IIf( [IdKioskEjra2] = [IdKioskEjra] ؛ "Ok"؛ "NoK") – Mehrdad
This problem repeat for every function that contain this character ؛ such as mid IdKioskEjraN: Mid( [IdKioskEjra2] ؛ 2؛ 4) – Mehrdad
That code should be in your post not in the comments. The functions should have commas between parameters not ؛ . – user6432984
Please post the SQL version of your query as text into body of your post. See SQL view. – Parfait

1 Answers

0
votes

The function iif requires the condition, iftrue, and iffalse to be separated with a comma, not a colon. Makr it look like this:

Iif(condition, ifTrue, ifFalse)