I have 2 tables that I have done a parent/child view with tables (PARTS and Order History). Works great. Then I created a parent/child view with a query for only certain records (Quotes and Order History). I receive the below error:
Technical information
Error number -2147217913
Error description [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
URL /ORDER_HISTORY_list.asp
SQL query select [PART], [ORDER_NO], [SC], [STATUS], [AWO], [PO], [QTY_ORIGINAL_ORDERED], [QTY_COMPLETED], [QTY_DUE], [UNIT_PRICE], [VENDOR NAME], [NATADMIN_ORD1_REMARKS], [CREATED_DATETIME], [COMPLETED_DOCDATE], [CREATED_USERID], [NATADMIN_ORDZ_REMARKS] From [ORDER HISTORY] where [PART] = 36152
I just don't get it. I have create parent/child views with tables, queries or both and I have never received this error. What can I do???? It is driving me crazy. I have seen where others have received this error and not answer is posted as to why. Can you please help me.....
Thx
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2980&image=1&table=forumtopics' class='bbc_emoticon' alt=':o' />