This may be a question that needs to be addressed in an Access group
but here it goes.

I have 2 tables (Client & Group) Some of the records in the Client
table are also part of a group which are coded as such in the Group
table. My problem is when I try to pull in data from both tables in
Access with MS Query (To MS Excel) it only pulls in data if the
records are part of a group. I am not filtering the data so I am not
sure why it is not pulling in the data.