VBA Inserting into Table, Sorting Issue

[psycoperl]

Good morning,

I am facing a dilemma that I cannot solve.

When I run the following code, the Order By in the Select Statement is not respected and the data in the table is not entered in order. When I run the Select statement by its self in the "Query Designer" it shows the records in the order that we need them to be.


DoCmd.RunSQL "Insert Into [tempTrTicket-M3] " & _
"SELECT TK.PrintedName, TK.TestCode, TK.TestDescription, TK.TestDate, TK.TestTime, TK.SRC, TK.Phase, TK.Type, TK.[Student ID], TK.[First Name], TK.MI, TK.[Last Name], TK.Address, TK.City, TK.State, TK.[Zip Code], UCASE(TK.Print) As Print , TK.TicketID, TK.TicketIDLN from [AppointmentTickets-M3-Transfers-1stAppt] TK ORDER BY TK.[Last Name] ASC, TK.[First Name] ASC, TK.MI ASC"

 

[xenou]

Hi it's possible there's sort order defined for the table (I find these a little confusing - but you can sort the table as you want it, then hit the "Save" button to save the "design" change to the table).

As a rule, there is no such thing as a sorted table, but in practice since I work in many of my own tables I do view data in the tables directly and have a sort order defined can be convenient. We never want end users to work with tables directly though - they can't be trusted