var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Order Entry Verification
I have 10 tables. Each table is for a separate branch of one company. Inside each table are 3 fields (WH_CODE, PROD_CLASS, AND GL_CODE).
When someone is entering information for each branch, I need to verify that they are entering correct information. I would like to create a query that will do the work for me.
WH_CODE PROD_CLASS GL_CODE
A1 L1 62349102
A1 LF 62349102
A1 P1 62356102
A1 PF 62356102
A1 SF 62363102
I need to ensure that the GL Code for any product class containing an "L" in warehouse A1 is correct (62349102) and return a result for any that are incorrect.
Any help would be greatly appreciated.
WHERE InStr(PROD_CLASS, "L") > 0 AND GL_CODE <> 62349102
It is giving me a syntax error in the query expression.
It would help to see the actual SQL, and the data types of the fields in the WHERE clause.