Make table query type looses data

[annux3]

Hello guys,

I cannot understand why does query type "make table" loose fields data from just "select" query type.

The code that access gives me looks like this:

SELECT STARMAN_AD_KATASTRIYKSUS.KATASTRITUNNUS, Esimene.*, STARMAN_EH_EHITIS_KATYKSUS.KAYK_ID INTO Finaalne
FROM (Esimene LEFT JOIN STARMAN_EH_EHITIS_KATYKSUS ON Esimene.EHIT_ID = STARMAN_EH_EHITIS_KATYKSUS.EHIT_ID) LEFT JOIN STARMAN_AD_KATASTRIYKSUS ON STARMAN_EH_EHITIS_KATYKSUS.KAYK_ID = STARMAN_AD_KATASTRIYKSUS.ID;

So when I just run this code as select, it gives me what I want aka everything from table "Esimene", KATASTRITUNNUS from table "STARMAN_AD_KATASTRIYKSUS" and also KAYK_ID from table STARMAN_EH_EHITIS_KATYKSUS
What this does not do, is put all those fields into new table called "Finaalne", fields are just blank.

I am so confused, does anybody has a clue what I might be doing wrong?

Thank you in advance,
Annu


EDIT*

Okay I will explain a little more, maybe the problem is related to previous actions.

First I made a table out of this code:

SELECT EE.*, Starman_eh_ehitis_aadress.EHIT_ID INTO Esimene
FROM EE LEFT JOIN Starman_eh_ehitis_aadress ON EE.ADR_ID = Starman_eh_ehitis_aadress.ADR_ID;

This worked like a charm.

Then I also wanted to make a table out of this code:

SELECT Esimene.*, STARMAN_EH_EHITIS_KATYKSUS.KAYK_ID INTO Teine
FROM Esimene LEFT JOIN STARMAN_EH_EHITIS_KATYKSUS ON Esimene.EHIT_ID = STARMAN_EH_EHITIS_KATYKSUS.EHIT_ID;

However this one made a table where field made from previous select and "make table" was also lost. aka now it made a table where Starman_eh_ehitis_aadress.EHIT_ID and STARMAN_EH_EHITIS_KATYKSUS.KAYK_ID are empty columns.

So in the end I tried eveything with one query:

SELECT EE.*, STARMAN_AD_KATASTRIYKSUS.KATASTRITUNNUS
FROM ((EE LEFT JOIN Starman_eh_ehitis_aadress ON EE.ADR_ID = Starman_eh_ehitis_aadress.ADR_ID) LEFT JOIN STARMAN_EH_EHITIS_KATYKSUS ON Starman_eh_ehitis_aadress.EHIT_ID = STARMAN_EH_EHITIS_KATYKSUS.EHIT_ID) LEFT JOIN STARMAN_AD_KATASTRIYKSUS ON STARMAN_EH_EHITIS_KATYKSUS.KAYK_ID = STARMAN_AD_KATASTRIYKSUS.ID;

But this did not work at all - gave me a error "Type mismatch in expression"

[ranman256]

it shouldn't. If you turn the select query into a make table qry, it should pull the exact same fields.

[CJ_London]

To be clear, when you say fields are blank, do you mean there are no records? or there are records but the fields are blank?

[annux3]

No records, just a column with a header.

[annux3]

Wait, never mind. There were just so many records, that I did not scroll down enough. I am so sorry, I am just an idiot.