[AccessD] SQL for Subquery being changed

I have a query which Access allows me to code in SQL, it shows up just fine
in Design View as well. Somewhere down the road Access changes the SQL.
Change from regular parentheses to square brackets. Is this normal behavior?


Also, sometimes the query stops running for no apparent reason. I go into
edit the SQL, essentially do nothing but remove the final semicolon and all
of a sudden it is running. Since a subform is based on this query it is very
annoying.

Original:
SELECT C.Max_Fuzzy, A.Plant_id AS IIR_Plant_ID, B.GIB_Owner_ID
FROM (tbl_IIR AS A LEFT JOIN qry_103_Matched_Plants_For_Display_All AS B ON
A.Plant_id=B.Sort_ID) LEFT JOIN 
   (SELECT IIR_Parent, Max(Multiply_Pct) AS Max_Fuzzy FROM tbl_Fuzzy_Matches
GROUP BY IIR_Parent) AS C 
   ON A.Parentname=C.IIR_Parent
WHERE (((B.Sort_ID) Is Null));

Access Changes to:
SELECT C.Max_Fuzzy, A.Plant_id AS IIR_Plant_ID, B.GIB_Owner_ID
FROM (tbl_IIR AS A LEFT JOIN qry_103_Matched_Plants_For_Display_All AS B ON
A.Plant_id=B.Sort_ID) LEFT JOIN 
   [SELECT IIR_Parent, Max(Multiply_Pct) AS Max_Fuzzy FROM tbl_Fuzzy_Matches
GROUP BY IIR_Parent; ] AS C 
   ON A.Parentname=C.IIR_Parent
WHERE (((B.Sort_ID) Is Null));