Syntax error missing operator in query expression

[Jeff Miller]

This error plagues my SQL and as the error is so generic and comprises multiple lines, I have nothing to search on.

I can correct it only to have an "Syntax error in UPDATE statement."

So, sample
Error begins at TRUE and ends before the WHERE.

UPDATE [Inspections SHELL]
SET  [Inspections SHELL].[Phase 1] = TRUE -- Toggle Yes/No on
INNER JOIN [Inspections Attempt]
ON ([Inspections SHELL].[Field] = [Inspections Attempt].[Field]) 
AND ([Inspections SHELL].[start] = [Inspections Attempt].[date])
WHERE ([Inspections Attempt].[Phase] = 1);
 

This is a reduction of the following code

UPDATE [Inspections SHELL]
SET  [Inspections SHELL].[Phase 1] = IIf([Inspections Attempt]![Phase]=1,True,False), --Toggle Phase 1 if Phase = 1
     [Inspections SHELL].[Phase 2] = IIf([Inspections Attempt]![Phase]=2,True,False), --Toggle Phase 2 if Phase = 2
     [Inspections SHELL].[18X Day] = IIf([Inspections Attempt]![Phase]=0,True,False), --Toggle 180 day if Phase = 0
    /* Toggle appropriate state if note indicates */
     [Inspections Shell].[Acceptence] = IIF(instr([Inspections Shell].[Notes], "Accept") > 0, true, false),
     [Inspections Shell].[Special] = IIF(instr([Inspections Shell].[Notes], "Spec") > 0, true, false),    
     [Inspections Shell].[CC] = IIF(instr([Inspections Shell].[Notes], "CC") > 0, true, false)    ,
     [Inspections Shell].[90 Day] = IIF(instr([Inspections Shell].[Notes], "90") > 0, true, false),
     [Inspections Shell].[1 Year] = IIF(instr([Inspections Shell].[Notes], "1 year") > 0, true, false),        
     [Inspections Shell].[2 Year] = IIF(instr([Inspections Shell].[Notes], "2 year") > 0, true, false),    
     [Inspections Shell].[W&B] = IIF(instr([Inspections Shell].[Notes], "&") > 0, true, false)    
FROM [Inspection SHELL] 
INNER JOIN [Inspections Attempt]
ON ([Inspections SHELL].[Field] = [Inspections Attempt].[Field]) 
AND ([Inspections SHELL].[start] = [Inspections Attempt].[date]);
 
Which has the same series of errors.
 

As a supplement, most update queries that I get to "work" will explode my database (going from 7 MB to 200 MB with a creation of 20,000+ null records). The only update that has worked has used bare minimum syntax, so the actual question may be "what am I missing with update syntax?"

[ADezii]

Try a change in Syntax, specifically the location of the SET Statement, as in:

UPDATE [Inspections SHELL]
INNER JOIN [Inspections Attempt]
ON ([Inspections SHELL].[Field] = [Inspections Attempt].[Field])
AND ([Inspections SHELL].[start] = [Inspections Attempt].[date])
SET [Inspections SHELL].[Phase 1] = True
WHERE [Inspections Attempt].[Phase] = 1;

[Jeff Miller]

That gets rid of the syntax problem... now to test it; but hat is supremely annoying, I found the relocation of the join in a forum but I got an error in UPDATE.

Will this method work for the mass update?

EDIT:

It doesn't join properly.

Each table has identical fields being inner joined, but I'm only getting 65 records returned of 312, and none of them have [Phase 1] = True.

[ADezii]

@Jeff - Can you Upload a Copy of the Database with a Minimal number of Records, stripped of any Personal Info, of course? This way, we can see the problem first hand.

[Jeff Miller]

I'll see what I can do.

Going to have to use an update query to scramble some of the data to enforce privacy.

UPDATE table
SET table.Field = Right([table]![Field],1) & Mid([table]![Field],2,2) & Left([table![Field], 3);
 

Should change all records such that ABCD would become DBCABC right? Because it's not doing -anything-, and I cannot submit it with the current fields as is, and they have to be all updated in the same format to preserve data relationship.