February 9, 2009 at 7:03 pm
I have a query that has been working that has recently broke. The error message is "Data Type Mismatch in Criteria Expression"
The join in the query joins two tables together. The join starts and gets to record 67 and then fails and give the above message. If I just take the top 66 records, it works fine.
The first of the two tables is a query itself. If I run the query by itself, the very last record says "#ERROR"
So it appears to be a data corruption issue. I filter for null records, for empty records etc. But still something is slipping in and I can't seem to find a solution for this.
If there is a better forum or website to post this on, that would be appreciated.
Greg
February 11, 2009 at 10:28 am
Well, I never found a cause for the error, but I rewrite the query to join on a different field and that worked. The field I was trying to join on was the ID column (an int) and instead I joined on the Company Name instead. Not the proper way to do it, but it worked.
Greg
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply