Syntax error (missing operator)

[BigGuy316]

Here is the error message I am getting along with the code:

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression 'IDFrm = 38 AND IDSpec ='.

Dim rsResults
Dim rsResults_numRows

Set rsResults = Server.CreateObject("ADODB.Recordset")
rsResults.ActiveConnection = MM_mis_STRING
rsResults.Source = "SELECT IDFrm, f107DateSubmitted, f107DateCompleteBy, f107FY, f107Status, IDspec, SpecText, f107POCIDfk, f107POCID, f107POCFName, f107POCLName, f107AircraftIDfk, AircraftID, AircraftSerialNo, f107MajorWorkArea, IDMajorWorkArea, Text, f107MajorSys, f107JCN, f107WUC, f107TechReq, f107DiscBy, f107ResLoc, f107RecRep, f107DesLoc, f107DrpIn, f107BluStrk FROM dbo_tblForm107, dbo_tblf107POC, dbo_tblAircraft, dbo_tblSpecsList, dbo_tblf107grpMajorWorkArea WHERE IDFrm = "& (rsIdentity.Fields.Item("LastIdent").Value) &" AND f107POCID = f107POCIDfk AND AircraftID = f107AircraftIDfk AND IDSpec = f107Status AND IDMajorWorkArea = f107MajorWorkArea"

Any help would be much appreciated.

Thanks!

[BigGuy316]

I posted the wrong coding in my earlier post.. Here is the correct code which the error is occuring with:

Dim rsDiscByResults
Dim rsDiscByResults_numRows

Set rsDiscByResults = Server.CreateObject("ADODB.Recordset")
rsDiscByResults.ActiveConnection = MM_mis_STRING
rsDiscByResults.Source = "SELECT IDFrm, f107DiscBy, IDSpec, SpecText FROM

dbo_tblForm107, dbo_tblSpecsList WHERE IDFrm = " &

(rsIdentity.Fields.Item("LastIdent").Value) & " AND IDSpec = f107MajorSys "
rsDiscByResults.CursorType = 0
rsDiscByResults.CursorLocation = 2
rsDiscByResults.LockType = 1
rsDiscByResults.Open()

[lakshmanmcaj]

hi,

try to use aliace name for two table that's problem may be try it

[BigGuy316]

Thanks.. It is working now.