Programming Forums > Application Development > Other Programming Languages

zorin · Sep 9th, 2005, 3:59 AM

OK, I know this is not VB but I need some help

When I am using ms access I carnt view some of the querys ive made but some I made are fine, I keep getting a message saying (data type mismatch in criteria expression), someone told me that its because the computers are on a network, is this true?

Pizentios · Sep 9th, 2005, 9:32 AM

nope, nothing to do with a network. The data type mismatch part makes me think your compairing two values that aren't of the same type. Or it could be that your trying to divide a integer by a double or something. In ether case, it's because you are doing some kind of operation (or compairison) with values who's data types don't match.

If you want, you could post the SQL for one of the querys, and one of us could probably help you out figuring out what's going on.

BTW, moved thread to Misc. forum.

Infinite Recursion · Sep 9th, 2005, 9:56 AM

Yeah, show us the SQL and a description of the table.

zorin · Sep 12th, 2005, 4:35 PM

OK, my mistake I was trying to compare two different types of data, but its right now but thanks for the help anyway

Pizentios · Sep 13th, 2005, 3:35 PM

no problem, that's why we're here :-)

Infinite Recursion · Sep 13th, 2005, 3:42 PM

glad you figured it out

Sep 9th, 2005, 3:59 AM	#1
zorin Hobbyist Programmer Join Date: Apr 2005 Posts: 218 Rep Power: 4	ms access OK, I know this is not VB but I need some help When I am using ms access I carnt view some of the querys ive made but some I made are fine, I keep getting a message saying (data type mismatch in criteria expression), someone told me that its because the computers are on a network, is this true?

Sep 9th, 2005, 9:32 AM	#2
Pizentios Programming Guru Join Date: May 2004 Location: Brandon, Manitoba, Canada Posts: 2,023 Rep Power: 7	nope, nothing to do with a network. The data type mismatch part makes me think your compairing two values that aren't of the same type. Or it could be that your trying to divide a integer by a double or something. In ether case, it's because you are doing some kind of operation (or compairison) with values who's data types don't match. If you want, you could post the SQL for one of the querys, and one of us could probably help you out figuring out what's going on. BTW, moved thread to Misc. forum. __________________ Profanity is the one language that all programmers understand. Check out my Blog <---updated Nov 30 2007!

Sep 9th, 2005, 9:56 AM	#3
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,467 Rep Power: 8	Yeah, show us the SQL and a description of the table. __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."

Sep 13th, 2005, 3:35 PM	#5
Pizentios Programming Guru Join Date: May 2004 Location: Brandon, Manitoba, Canada Posts: 2,023 Rep Power: 7	no problem, that's why we're here :-) __________________ Profanity is the one language that all programmers understand. Check out my Blog <---updated Nov 30 2007!

Sep 13th, 2005, 3:42 PM	#6
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,467 Rep Power: 8	glad you figured it out __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."

Sep 12th, 2005, 4:35 PM	#4
zorin Hobbyist Programmer Join Date: Apr 2005 Posts: 218 Rep Power: 4	OK, my mistake I was trying to compare two different types of data, but its right now but thanks for the help anyway

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode