It did not return any data.. I think I did something wrong.. here is my sql:
SELECT DISTINCT tblRQ.RQ_USER_13, tblRQ.RQ_REQ_ID, tblRQ.RQ_ID, tblRQ.RQ_REQ_NAME, tblChangeRequest.ID
FROM tblRQ, tblChangeRequest
WHERE (([ID] In (" & [RQ_ID] & ")));
example data:
tblRQ tblChangeRequestRQ_ID...