I apologize in advance if this question has been answered before. I am an newbie to MS Access and Queries, I have been stuck on this for a couple of days and need help.
If I have two Tables with the following fields
TableA 8000 records
DocID
Field2
Field3
Field4
......
TableB 200 records
DocID
Field2
Field3
......
What I am trying to accomplish is to take the DOCIDs from TableB and find the matching DOCIDs in TableA. Once found, I would like the query to show all of the data from TableA "DOCID, Field2, Field3, Field4 ......" I have been trying to do this with a Right Join in my query with no success.
Thanks in advance