Hello,
Jup, das Problem kenne ich. Access versteht die Alias-Vergabe nicht, d.h. es ist nicht möglich darauf eine Sortierung (und ich glaube auch keine WHERE-Kriterien) anzuwenden.
Mir bekannter Ausweg ist die Adressierung mittels des Spaltenindex, also z.B. ORDER BY 1
MfG
Rouven
--
-------------------
"I wish it need not have happened in my time" - "So do I, and so do all who live to see such times. But that is not for them to decide. All we have to decide is what to do with the time that is given us." -- J.R.R. Tolkien: "The Lord Of The Rings: The Fellowship Of The Ring"
-------------------
"I wish it need not have happened in my time" - "So do I, and so do all who live to see such times. But that is not for them to decide. All we have to decide is what to do with the time that is given us." -- J.R.R. Tolkien: "The Lord Of The Rings: The Fellowship Of The Ring"