how do i deal with the error "DATA TYPE MISMATCH IN CRITERIA EXPRESSION" in VB6?

dataExam.RecordSource = "SELECT [exam score] FROM exams WHERE [Sctr] = '" & DataStudandClass.Recordset(0).value & "' AND [Cctr] = '" & DataStudandClass.Recordset(1).value & "'"

dataExam.Refresh 'when i click debug, this line is highlighted

Update:

Both Sctr and Cctr are autoNumbers...

3 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    You need to check the datatypes for [Sctr] and [Cctr] and verify that you are plugging in the right data type. It is hard to give you a solution without seeing the types of the table.

    ***EDIT***

    Are you using single quotes for the numbers? It is kind of hard to tell here. Do not use single quotes or double quotes for numeric values. Just a thought.

    • Commenter avatarLogin to reply the answers
  • launer
    Lv 4
    4 years ago

    it is traditionally a bother along with your the placement clause. you're announcing "the place 'something' equals 'some element else'. those 2 values must be on the instant comparable, the two provided that they are the comparable documents type (e.G. each and each numbers), or they're close enogh for an implicit conversion. Double ensure your total '=' and ensure the two gadgets are the equivalent documents form.

    • Commenter avatarLogin to reply the answers
  • 1 decade ago

    It's probably a problem with your WHERE clause. You are saying "Where 'something' equals 'something else'. Those two values need to be directly comparable, either because they are the same data type (e.g. both numbers), or they are close enogh for an implicit conversion.

    Double check all of your '=' and make sure the two items are the same data type.

    • Commenter avatarLogin to reply the answers
Still have questions? Get your answers by asking now.