Access changes my fields order

[SimonB1978]

Hi

I have a query that looks go like this:

SELECT *, "Last column" AS LAST_COL
FROM MY_TABLE

It all work fine. Then I want to create a table out of it:

SELECT *, "Last column" AS LAST_COL INTO NEW_TABLE
FROM MY_TABLE

If I save my query and re-open it, Access has modified it into the following:

SELECT "Last column" AS LAST_COL, * INTO NEW_TABLE
FROM MY_TABLE

The thing is a UNION query is to be done afterwards, so my columns do not line up anymore. There is a lot already existing to change the structure of the tables.

Anyone has a clue why Access does that? Can I prevent it form doing it?

Thank you,

Simon B.

 

[Brianwarnock]

Code
Select my_table.*,etc

Brian

 

[SimonB1978]

That worked.

Thank you very much.

Simon B.