How do you trouble shoot a “Data type mismatch in criteria expression” error in MS Access 2010?

The criteria expression is the part of the query containing the conditions, as in WHERE <condition>. Look at those specifically. The error message means you’re comparing two things (this equals that, or this less than that, etc.) that are of two different, and incompatible types (comparing a number to a string, for example).

You can find out which condition is causing the problem by deleting them one at a time and testing again each time until the error disappears.

Make sure you save a copy of your original query, or make a new copy for testing.

Related Posts:

  1. Why do we need “Relationships” between tables at all?
  2. How to SUM two fields within an SQL query
  3. “You tried to execute a query that does not include the specified aggregate function”
  4. How do I count unique items in field in Access query?
  5. What’s the best way to search for a UPC code in a Database?
  6. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  7. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  8. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  9. What is the difference between UNION and UNION ALL?
  10. Selecting COUNT(*) with DISTINCT
  11. Case in Select Statement
  12. What is a stored procedure?
  13. ORA-00904: invalid identifier
  14. SQL WITH clause example [duplicate]
  15. Unknown column in ‘field list’ error on MySQL Update query
  16. Unknown column in ‘field list’ error on MySQL Update query
  17. SQL Inner-join with 3 tables?
  18. The wait operation timed out. ASP
  19. What is SELF JOIN and when would you use it? [duplicate]
  20. The wait operation timed out. ASP
  21. Conversion failed when converting date and/or time from character string while inserting datetime
  22. Self Join to get employee manager name
  23. How do I UPDATE from a SELECT in SQL Server?
  24. how to fix oracle ORA-01722 invalid number error
  25. SQL query to select dates between two dates
  26. MySQL – Operand should contain 1 column(s)
  27. SQL SELECT WHERE field contains words
  28. Conversion failed when converting date and/or time from character string while inserting datetime
  29. When should I use CROSS APPLY over INNER JOIN?
  30. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  31. Insert Data Into Temp Table with Query
  32. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  33. MySQL create table if not exists and insert record only if table was created
  34. error, string or binary data would be truncated when trying to insert
  35. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  36. NOT IN vs NOT EXISTS
  37. SQL SELECT WHERE field contains words
  38. Online SQL Query Syntax Checker
  39. How can I do an UPDATE statement with JOIN in SQL Server?
  40. Must declare the scalar variable
  41. ORA-00979 not a group by expression
  42. ORA-00907: missing right parenthesis
  43. How do I use properly CASE..WHEN in MySQL
  44. Must declare the scalar variable
  45. Rename column SQL Server 2008
  46. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  47. Using group by on multiple columns
  48. Efficiently convert rows to columns in sql server
  49. How can I do a FULL OUTER JOIN in MySQL?
  50. Nested select statement in SQL Server
  51. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  52. Using group by on multiple columns
  53. SQL SELECT WHERE field contains words
  54. MySQL query String contains
  55. How do I escape a single quote in SQL Server?
  56. What’s the difference between VARCHAR and CHAR?
  57. Case statement in MySQL
  58. T-SQL split string based on delimiter
  59. How to declare a variable in MySQL?
  60. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  61. Finding duplicate values in a SQL table
  62. ORA-01843 not a valid month- Comparing Dates
  63. MySQL Cannot Add Foreign Key Constraint
  64. Drop a temporary table if it exists
  65. How do I escape a single quote in SQL Server?
  66. ORA-00918: column ambiguously defined in SELECT *
  67. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  68. How Stuff and ‘For Xml Path’ work in SQL Server?
  69. IDENTITY_INSERT is set to OFF – How to turn it ON?
  70. Oracle error : ORA-00905: Missing keyword
  71. How to split the name string in mysql?
  72. How to reset AUTO_INCREMENT in MySQL
  73. How do I import an SQL file using the command line in MySQL?
  74. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  75. mysql Foreign key constraint is incorrectly formed error
  76. How do I limit the number of rows returned by an Oracle query after ordering?
  77. Sql Server equivalent of a COUNTIF aggregate function
  78. Oracle SELECT TOP 10 records
  79. MySQL: Invalid use of group function
  80. must appear in the GROUP BY clause or be used in an aggregate function
  81. Column name or number of supplied values does not match table definition
  82. Inserting data into a temporary table
  83. Can a foreign key be NULL and/or duplicate?
  84. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  85. Why does NULL = NULL evaluate to false in SQL server
  86. How to Select Top 100 rows in Oracle?
  87. Simple PHP Pagination script
  88. How do composite indexes work?
  89. CREATE VIEW must be the only statement in the batch
  90. How can I return pivot table output in MySQL?
  91. SQL Server FOR EACH Loop
  92. Difference between JOIN and INNER JOIN
  93. ORA-12560: TNS:protocol adaptor error
  94. Compare dates in MySQL
  95. Best way to do nested case statement logic in SQL Server
  96. How can I select the first day of a month in SQL?
  97. Difference between one-to-many and many-to-one relationship
  98. MySQL “WITH” clause
  99. What is the difference between JOIN and UNION?
  100. MySQL Multiple Joins in one query?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)