F
FRAN
I HAVE THE FOLLOWING SITUATION IN A TABLE WITHIN FIELD1
AND FIELD2: I AM USING ACCESS 2002.
FIELD1 FIELD2
J.DAVIS L.SMITH
L.DAVIS J.SYMTH
M.DAVIS J.DAVIS
N.DAVIS K.ANA
O.DAVIS M.DAVIS
I WOULD LIKE TO QUERY THE RECORDS FROM FIELD1 THAT MATCH
THE RECORDS IN FIELD2. I HAVE TRIED DOING THIS WITH A
SELECT QUERY AND I CONTINUE TO GET "NO RECORDS FOUND".
CAN SOMEONE PLEASE TELL ME HOW TO DO THIS?
AND FIELD2: I AM USING ACCESS 2002.
FIELD1 FIELD2
J.DAVIS L.SMITH
L.DAVIS J.SYMTH
M.DAVIS J.DAVIS
N.DAVIS K.ANA
O.DAVIS M.DAVIS
I WOULD LIKE TO QUERY THE RECORDS FROM FIELD1 THAT MATCH
THE RECORDS IN FIELD2. I HAVE TRIED DOING THIS WITH A
SELECT QUERY AND I CONTINUE TO GET "NO RECORDS FOUND".
CAN SOMEONE PLEASE TELL ME HOW TO DO THIS?