CODEWITHSUNDEEP
sqlms-access
Gregory
Gregory

Reputation: 1

SQL Syntax error (missing operator) in query expression

I keep getting this error and I can’t figure out why. If anyone could help it would be much appreciated.

Syntax error (missing operator) in query expression ‘(((plot.[annual charge]) Like "*")) UPDATE Plot SET Plot . [annual charge] = IIF([annual charge]<,[annual charge]+[annual charge]*15/100,[annual charge]*10/100);

Code:

SELECT plot.[annual charge]
FROM (
    (
        member INNER JOIN plot ON (member.[member number] = plot.[member table])
            AND (member.[member number] = plot.[member table])
            AND (member.[member number] = plot.[member table])
        ) INNER JOIN produce ON plot.[plot number] = produce.[plot number]
    )
INNER JOIN vegetables ON produce.[vegtable name] = vegetables.[vegetable name]WHERE (((plot.[annual charge]) LIKE "*"))UPDATE Plot
SET Plot.[annual charge] = IIF([annual charge] <, [annual charge] + [annual charge] * 15 / 100, [annual charge] * 10 / 100);

Upvotes: 0

Views: 604

Answers (2)

mya
mya

Reputation: 1

you might want to check your parenthesis. there is an opening brace with no closing brace if i am not mistaken. that could be the cause of your error.

Upvotes: 0

Sergey S.
Sergey S.

Reputation: 6336

Try this:

UPDATE (
        (
            member INNER JOIN plot ON (member.[member number] = plot.[member table])
                AND (member.[member number] = plot.[member table])
                AND (member.[member number] = plot.[member table])
            ) INNER JOIN produce ON plot.[plot number] = produce.[plot number]
        )
INNER JOIN vegetables ON produce.[vegtable name] = vegetables.[vegetable name]
WHERE (((plot.[annual charge]) LIKE "*"))
SET Plot.[annual charge] = IIF([annual charge] < 1000000, [annual charge] + [annual charge] * 15 / 100, [annual charge] * 10 / 100);

Replace 1000000 by desired number

Upvotes: 1

Related Questions