Problem editing queries

[arvindn]

Consider the foll. query


SELECT pinvtrn.*, LASTSALESBILL, SALESPCS, SALESMTS, LASTSALESBILL, LASTSALESDATE, SALESPARCELS, SALESRATE, SALESADAT, BILLS.DATE
FROM ((BILLS INNER JOIN PINVTRN ON (BILLS.CNO=PINVTRN.CNO) AND (BILLS.TYPE=PINVTRN.TYPE) AND (BILLS.VNO=PINVTRN.VNO)) INNER JOIN COMPMST ON BILLS.CNO=COMPMST.CNO) LEFT JOIN [SELECT GREYSALEBILLDET.CNO,GREYSALEBILLDET.PVNO,SUM(PCS) AS SALESPCS,SUM(MTS) AS SALESMTS,MAX(GREYSALEBILL.VNO) AS LASTSALESBILL,MAX([DATE]) AS LASTSALESDATE,AVG([RATE]) AS SALESRATE,SUM(PARCELS) AS SALESPARCELS,AVG(ADAT) AS SALESADAT FROM GREYSALEBILLDET INNER JOIN BILLS AS GREYSALEBILL ON GREYSALEBILLDET.CNO=GREYSALEBILL.CNO AND GREYSALEBILLDET.TYPE=GREYSALEBILL.TYPE AND GREYSALEBILLDET.VNO=GREYSALEBILL.VNO GROUP BY GREYSALEBILLDET.CNO,GREYSALEBILLDET.PVNO]. AS GREYSALEBILLDET2 ON (BILLS.CNO=GREYSALEBILLDET2.CNO) AND (BILLS.VNO=GREYSALEBILLDET2.PVNO);


When i use a nested Sql select statement as in above and save the query and later on re-open it for editing the ( and ) brackets are automatically replaced by [ and ]. respectively and makes editing such queries very painful. Any ways to get around this? Thanks.

 

[GGib7711]

Instead of using a one-query approach, I think you can use a two-query approach.

Save the nested SQL statement as a separate query. Then link to this query in your original query.

 

[arvindn]

Thanks for replying.

But, I am looking for other options than the one u mentioned.

Does anyone know of a good free query editor for Access available as an add-in ?