Access team should also update SQL editor windows to remain text as is we save. Means, we format SQL syntax each field name in one line to make it easier to read and understand. But, after saving and reopening to SQL view it mix-up all filed in one line which is very clumsy.
SELECT tblManufacture.POS,
tblManufacture.WCH,
Sum(tblManufacture.ManufactureQty) AS Total,
Max(tblManufacture.MDateTime) AS [Last Edit]
FROM tblManufacture
GROUP BY tblManufacture.POS, tblManufacture.WCH
HAVING (((tblManufacture.WCH)=15));
Above is a simple SQL statement I edit in SQL view and save it then close the editor window. When I reopen the query in SQL view then it shows like-
SELECT tblManufacture.POS, tblManufacture.WCH, Sum(tblManufacture.ManufactureQty) AS Total, Max(tblManufacture.MDateTime) AS [Last Edit]
FROM tblManufacture
GROUP BY tblManufacture.POS, tblManufacture.WCH
HAVING (((tblManufacture.WCH)=15));
Access team should improve so that I can see same as before as I save the query.