Hi Everyone,
I am new to MS Access and i am in need of a requirement in Access as below.
I have a table with column "COL1" and column "COL2" with values as below.
COL1 COL2
----------------------
A 10
A 20
A 30
B 20
B 30
C 10
C 20
D 20
D 30
In here i must read COL1 and on the first occurrance of "A" it must check value in COL2 is 10. If it is not 10 then it must return "FALSE" Message as value in a new field,else it must return "TRUE" as value in a new field..
Same must occur for B,C,D etc..
Please help me in writing a VBA code or by means of Query.
Thanks in advance.
Regards
Kcgp