Clipper2000
Programmer
Hi everyone,
I have a query that is working perfectly except that some how my Access ALWAYS convert the ( into [ and add a period after the ] when I saved this query:
Thus, please do me a big favor by paste the query below to your Access query and save it, then open it again to see if Access has messed up the brackets. You don't need to have the tables setup, just paste the query as is will do.
Thanks in advance and thank you PHV for answer this question earlier.
I have a query that is working perfectly except that some how my Access ALWAYS convert the ( into [ and add a period after the ] when I saved this query:
Thus, please do me a big favor by paste the query below to your Access query and save it, then open it again to see if Access has messed up the brackets. You don't need to have the tables setup, just paste the query as is will do.
Thanks in advance and thank you PHV for answer this question earlier.
Code:
SELECT B.GLM, A.Description, A.Accpac, A.Amount, A.Category, A.Period, A.Year
FROM [tbl90707(Single)] AS A INNER JOIN (SELECT DISTINCT GLM, Accpac FROM [GLM:ACCPAC]) B ON A.Accpac = B.Accpac
WHERE A.Accpac < "40000" AND A.Category <>"CFI" AND A.Period = 11 and A.Year = 2004;