Data Type Mismatch

  • Thread starter Thread starter mattc66 via AccessMonster.com
  • Start date Start date
M

mattc66 via AccessMonster.com

I am getting a Data Type MisMatch. I think it's because the below is looking
for TEXT Match and I need it to look for a Number Match. What would I change
the syntax to if I want to match two number flds?

strSQL = "Select * From tblName Where fldNameID = '" & rs1![fldNameID] & " '"

Thanks
Matt
 
Eliminate the ' delimiters:

strSQL = "Select * From tblName Where fldNameID = " & rs1![fldNameID]
 
Back
Top