Can anybody sus out what is wrong with this
I get the error
Thanks a bunmch
P
Code:
Set qdfTemp = dbsCurrent.CreateQueryDef("")
With qdfTemp
.SQL = "SELECT T.ITIME, T.LINE, T.ISLAND, T.TAGVALUE-Nz(V.TAGVALUE,0) AS Total " _
& "FROM TMP_DAILY_TABLE AS T INNER JOIN TMP_DAILY_TABLE AS V ON (T.DISPLAYNAME=V.DISPLAYNAME) AND (Format(T.IDATE,""yyyymmddhhnn"")=Format((V.IDATE+#12/30/1899 0:15:0#),""yyyymmddhhnn"")) " _
& "WHERE T.DISPLAYNAME like " & G_Desk & ""
End With
Set rstTemp = qdfTemp.OpenRecordset
With rstTemp
.MoveLast
.MoveFirst
End With
I get the error
Code:
Run time error '3075'
Syntax error (missing operator) in query expression 'T.DISPLAYNAME like Dest 41'.
Thanks a bunmch
P