Microsoft Access: SQL View - Subquery aliases This is really annoying

[Pobo]

Hi All

Please does anyone know how to stop Microsoft Access changing my SQL scripts to use the "]. AS" notation for subquery aliases in the SQL view.

For example:

SELECT *
FROM (SELECT [GED Accounts].[EAS Account]
FROM [GED Accounts])SUBQUERY1;

becomes,

SELECT *
FROM [SELECT [GED Accounts].[EAS Account]
FROM [GED Accounts]]. AS SUBQUERY1;

The answer would be very much appreciated!


Thanks

Pobo