DUH?!?!?

[Bam_BamIR]

getting "missing operator in sql query" anyon egot an idea?






sSQL1 = "SELECT * FROM [Service Calls] WHERE [Service Calls.Date] BETWEEN #" & sDateFrom & "# AND #" & sDateTo & "# INNER JOIN [Service Calls] ON [Customer Info.Cust ID Number] = [Service Calls.Cust ID Number] SORT BY Date,Time"

[Clunietp]

try changing this:
SORT BY Date,Time

to this:
ORDER BY [Date], [Time]

[JHausmann]

You may need to qualify the tables the sort fields belong to...

[Bam_BamIR]

already qualified the order by but still getting attitude
basically trying to combine 2 tables into an object and selecting recordsets based on the date and then sorting them out heres what i got so far:

'sSQL1 = "SELECT * FROM [Customer Info] WHERE [Cust ID Number] in( SELECT [Cust ID Number] FROM Appointments WHERE Appointments.Date BETWEEN #" & sDateFrom & "# And #" & sDateTo & "# )"
'sSQL1 = "SELECT * FROM Appointments WHERE Date BETWEEN #" & sDateFrom & "# AND #" & sDateTo & "# ORDER BY Appointments.Date,Appointments.Time"
sSQL1 = "SELECT * FROM Appointments WHERE Date BETWEEN #" & sDateFrom & "# AND #" & sDateTo & "# ORDER BY Appointments.Date,Appointments.Time WHERE [Cust Info] WHERE [Cust Info.Cust ID Number]=[Appointments.Cust ID Number]"


Set apptRSResult = mdiDBMain.objDataBase.OpenRecordset(sSQL1, dbOpenSnapshot) 'new rs from sdatefrom to sdateto