I have a simple database linked to an exel spreadsheet. I was printing reports (class lists) from it without a problem until today. Now I get an error message stating that data type mismatch in criteria expression. I can't think of where else to look for the problem... Any help would be greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data type mismatch in criteria expression 1
- Thread starter ISTodd
- Start date
-
1
- #2
PaulBricker
Programmer
It's most likely a corrupt record. Usually an null value creeps in to field someplace and wacks things. You can try importing everything into a new database and see if that helps. If you have a bad record someplace, it will probably error out on that table and that will narrow things for you.
Paul
Paul
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
