Hi!
I have a table with two fields (Data and Check). The field "Data" has 10 records.
John
Mike
Julie
Julie
Tom
Harry
Harry
Harry
****
Vicky
The field "Check" has all blank records.
Can we write a Query/SQL Statement/VBA Code to check the names in the "Data" field and populate "YES" in the check field?
For instance:
Record1 of Field1 "Data" (John) is NOT EQUAL TO Record2 of Field1 "Data" (Mike) therefore, Record1 of Field2 "Check" should still be blank.
but
Record3 of Field1 "Data" (Julie) is EQUAL TO Record4 of Field1 "Data" (Julie) therefore, Record3 of Field2 "Check" should contain the value "YES".
Can this be done?
Maxi
I have a table with two fields (Data and Check). The field "Data" has 10 records.
John
Mike
Julie
Julie
Tom
Harry
Harry
Harry
****
Vicky
The field "Check" has all blank records.
Can we write a Query/SQL Statement/VBA Code to check the names in the "Data" field and populate "YES" in the check field?
For instance:
Record1 of Field1 "Data" (John) is NOT EQUAL TO Record2 of Field1 "Data" (Mike) therefore, Record1 of Field2 "Check" should still be blank.
but
Record3 of Field1 "Data" (Julie) is EQUAL TO Record4 of Field1 "Data" (Julie) therefore, Record3 of Field2 "Check" should contain the value "YES".
Can this be done?
Maxi