JET Query change "(" to "[" when saved 1

[Clipper2000]

Hi,

I have a SQL statement (as below) that works fine when run; however, after I save it and the next time I open the query, Access change the "(" to "[" and added an extra period (".") at the end. ????? why ???? Help please!

SELECT B.GLM, A.Description, A.Accpac, A.Amount, A.Category, A.Period, A.Year

FROM [tbl90707(Single)] A INNER JOIN (SELECT DISTINCT GLM, Accpac FROM [GLM:ACCPAC]) As B ON
A.Accpac = B.Accpac

WHERE A.Accpac < "40000" AND A.Category <>"CFI" AND A.Period = 11 and A.Year = 2004

Some how Access changed my second select clause to this when saved (note the extra period at the end:

INNER JOIN [SELECT DISTINCT GLM, Accpac FROM [GLM:ACCPAC]]. As B

 

[PHV]

To avoid this behaviour (bug ?) use a saved query.
Or, with your example:
SELECT DISTINCT B.GLM, A.Description, A.Accpac, A.Amount, A.Category, A.Period, A.Year
FROM [tbl90707(Single)] A INNER JOIN [GLM:ACCPAC] B ON
A.Accpac = B.Accpac
WHERE A.Accpac < "40000" AND A.Category <>"CFI" AND A.Period = 11 and A.Year = 2004

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Clipper2000]

You are a very clever person PHV! and you know your JOINs well!