Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2009

    Red face Unanswered: data Type mismatch

    what does the "Data type mismatch error" mean.

    I am running a querry on 5 colums the querry runs and gives output for the first three and than gives the above error
    what causes that

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    data type mismatch means that the compiler / interpreter / sql engine has received a value of a type its not expecting

    often it means that the you have supplied a numeric argument/parameter when it was expecting a string or vice versa
    ...where mycolumn = 1
    is not the same as
    ...where mycolumn = "1"
    it could be that you have supplied a date value when a number was expected, it coudl be the date value is not in the style that the wahtever expected.. eg you may may have supplied it in the form dd/mm/yyyy when Access normally expects mm/dd/yyyy.

    it could jsut be masking a syntax error in your SQL, ie its not valid SQL and the wahtever is whinging because it cannot understand what you are trying to do
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    Could be a number of things. My guess is a Null value in the data somewhere. What's the SQL of the query?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts