Hello!
I am a newbie with script, and a beginner with Access 2007 with ability to create basic queries, etc.
For the following table I am creating for work, I need code that will query to ONLY display the rows of Product Codes (PROD CODE), where subsequent rows of that product code of money1 and money2 columns (MON1 and MON2) do not net. Multiple rows exist, and if possible, we only need to see the rows that do not pair off for each product.
The attached sample table is marked with asterisks for the rows that need to to be removed from the result of the query.
SORRY, pasting the table is messy. Imagine the number values alternate, from column MON1 in first row to MON2 in second row, etc.
I cannot hand-write code yet, so I would appreciate any help!
PROD CODE MON1 MON2 CWM
AAI -120 W
AAI -120 C
AASS 15300 W
AASS 15300 C
AASS 44198 W
AASS 44198 C
AASS 804 W *
AASS 904 C *
ABC -11100 W
ABC -11100 C
ABJO -30 C
ABJO -20 W
ABJO -50 C
ABXQ 2650 C *
ADPW 2205 W
ADPW 2205 C
