My basic objective is simply to report the data I have generated with Fill_Temp_Services in the order that I need it to come out in. SQL Server 7 seems to have a mind of it's own on what order it releases the info to the report designer. The code shown below is generating the correct original set of data, and the Report is functioning OK (It is set up by "drag and drop" from the tblTempData fields).
I thought I might be able to over ride the desires of SQL Server by dumping the data into a temporary rs and then sending it back to tblTempData again and stipulate the "Order". The sp(s) were my original idea of how to do this.
The code below (True that I did not have to go the sp route) is doing OK EXCEPT that the ordering does not do anything. I have tried the "Order By" on both Select statements with the same results. SQL Server still prevails with the order it prefers (Scrambled) to go.
Actually, blaming it on SQL Server is an assumption on my part. I don't really know at this point.
Option Explicit
' Services List by Teacher
Private Sub DataReport_Initialize()
SECon = False
RSCon = False
SACon = False
'On Error Resume Next
Dim prstT As Recordset
Set prstT = frmFindReport.adoTemp.Recordset
Call Clr_Temp(prstT)
Call Fill_Temp_Services
Set rsSQLTempData = New Recordset
rsSQLTempData.Open "Select * into #rsSQLTempData from tblTempData", pCon
Call Clr_Temp(prstT)
rsSQLTempData.Open "Select * into #tblTempData from rsSQLTempData Order by Temp13, Temp6, Temp11", pCon
Dim psecH As Section
Set psecH = rptServicesSummary.Sections("Head"

pstrSName = Find_ID(frmFindReport.adoStudent, pstrFID, 0, 25)
psecH.Controls("lblName"

.Caption = pstrSName
psecH.Controls("lblID"

.Caption = pstrFID
psecH.Controls("lblReason"

.Caption = pstrFReason
psecH.Controls("lblMDate"

.Caption = Find_ID(frmFindReport.adoBasic, pstrFID, 0, 3)
End Sub
TIA
Ralph D. Meredith