Error 3075 - Missing Operator

[kermit5]

Here is my code

Dim intMasterProjectID, intContractorListID As Integer
    Dim strSQL, strContractor As String
    Dim dbs As Database
    Dim rs As dao.Recordset
    
    intMasterProjectID = Forms![Bid - Master Form]![Master Project ID]
    strContractor = Forms![Bid - Master Form]![Bid - Bid Follow Up]![FollowupContractor]
    strSQL = "SELECT * FROM [Bid - Contractor List]" & _
            "WHERE [Bid - Contractor List].[Contractor] = " & strContractor & _
            " AND [Bid - Contractor List].[Master Project ID] = " & intMasterProjectID
            
    Debug.Print "Project ID: " & intMasterProjectID
    Debug.Print "Contractor: " & strContractor
    Debug.Print "SQL: " & strSQL
    Set dbs = CurrentDb
    Set rs = dbs.OpenRecordset(strSQL)

I get error 3075 in my strSQL statement (syntax error (missing operator) in query expression...). Any Ideas?

Here is my SQL statement from my immediate window:

SQL: SELECT * FROM [Bid - Contractor List]WHERE [Bid - Contractor List].[Contractor] = Bud Bailey Construction AND [Bid - Contractor List].[Master Project ID] = -8585313

Thanks

 

[Fuga]

Do you need the ; at the end of the sql?

Fuga.

 

[kermit5]

I'm not sure I understand what you are asking?

If I include a semi-colon here:

strSQL = "SELECT * FROM [Bid - Contractor List] As myTable " & _
            "WHERE myTable.Contractor = " & strContractor & _
            " AND myTable.[Master Project ID] = " & intMasterProjectID;

I get a compile error: expected end of statement.

 

[Fuga]

I don´t really know what I´m talking about here, but I noticed a sql I have in a module and it end with the ; (I was trying to make a blue semicolon, hmm...)

    strSQL = "SELECT * FROM [Bid - Contractor List]" & _
            "WHERE [Bid - Contractor List].[Contractor] = " & strContractor & _
            " AND [Bid - Contractor List].[Master Project ID] = " & intMasterProjectID [b]& ";"[/b]

Like I said, just a thought.

Fuga.

 

[kermit5]

Unfortunately, I still get the same error.

 

[Fuga]

Ok, then I´m sorry I don´t know. Maybe the problem is in the strcontractor line?

Fuga.

 

[kermit5]

Thank you. You were correct. Here is what it required:

strSQL = "SELECT * FROM [Bid - Contractor List] " & _
            "WHERE [Master Project ID] = " & intMasterProjectID & _
            "AND [Contractor] = '" & strContractor & "'"

Because strContractor is a string variable, I need to set it off with single quotation marks in my SQL statement.

Thanks for your help.