"Type mismatch"

SishKabab · May 3rd 2006

Having trouble getting this sql statement to work, gives the Type mismatch error. Any ideas what I'm doing wrong?

Code

.CommandText = Array( _
        "SELECT CUSTINVOICETRANS.QTY " & Chr(13) & "" & Chr(10) & _
        "FROM AXDB.Bmssa.CUSTINVOICETRANS CUSTINVOICETRANS" & Chr(13) & "" & Chr(10) & _
        "WHERE (CUSTINVOICETRANS.ITEMID='MFD101')" & _
        "AND (CUSTINVOICETRANS.INVENTSERIALID" & _
        "IN (SELECT CUSTINVOICETRANS2.INVENTSERIALID" & Chr(13) & "" & Chr(10) & _
        "FROM AXDB.Bmssa.CUSTINVOICETRANS CUSTINVOICETRANS2" & Chr(13) & "" & Chr(10) & _
        "WHERE (CUSTINVOICETRANS2.ITEMID='RMI01')" & _
        "AND (CUSTINVOICETRANS2.INVENTSERIALID=CUSTINVOICETRANS.INVENTSERIALID)))")
        .Name = "Axa"
        .FieldNames = False
        .RowNumbers = False
        .FillAdjacentFormulas = False
        .PreserveFormatting = True
        .RefreshOnFileOpen = False
        .BackgroundQuery = True
        .RefreshStyle = xlInsertEntireRows
        .SavePassword = False
        .SaveData = True
        .AdjustColumnWidth = False
        .RefreshPeriod = 0
        .PreserveColumnInfo = True
        .Refresh BackgroundQuery:=False

Display More

gollem · May 4th 2006

Re: "Type mismatch"

According to me this does the same, I could be wrong:

Code

"SELECT CUSTINVOICETRANS.QTY " & Chr(13) & "" & Chr(10) & _ 
"FROM AXDB.Bmssa.CUSTINVOICETRANS CUSTINVOICETRANS" & Chr(13) & "" & Chr(10) & _ 
"WHERE CUSTINVOICETRANS.ITEMID = 'MFD101' and CUSTINVOICETRANS.ITEMID  = 'RMI01'

SishKabab · May 4th 2006

Re: "Type mismatch"

Well the logic is like this:

Find a product line of "MFD101" and see if it has an installation "RMI01" line with the same serial ID.

They are both sepearte product lines, so that is the problem.

"Type mismatch"

Participate now!

Share