Hi, new member hope you can help.

I have an access database that connects via ODBC to a DB2 table on an as400. A have a query that returns a result based on an OR statement on two separate fields, ie return result be either order number OR waybill number. It works fine within access 97 but when converted or recreated exactly the same in access 2002 constantly returns ODBC error 3146. Removing one of the prompts so it only searchs one field works fine. The AS400 is at OS level V4.5.

Any assistance is greatly received.