i am getting the message "Type Mismatch"

  • Thread starter Thread starter prasanna
  • Start date Start date
P

prasanna

When i am trying to open the query i am getting the message "Type Mismatch".

Please explain how to resolve?
 
The message means that JET is trying to compare 2 things that don't match,
e.g. comparing text to a number or a date. The solution will be to identify
where the mismatch is occurring.

A common problem occurs where you have an expression as a field. The data
type of the expression may not be what you expect, so you may need to
typecast it. More info:
http://allenbrowne.com/ser-45.html

The mismatch could be in the JOIN. For example, if you have 2 table in the
upper pane of query design, and you joined an AutoNumber field to a text
field, you have a mismatch.

Similarly, the mismatch could be in the criteria. If you can't find it,
start removing criteria until the problem goes away. You then know where it
is.

The problem could also be in the query's Filter or OrderBy properties. Clear
these.

If you are still stuck, switch your query to SQL View. Copy the SQL
statement, and post it here.
 
Back
Top