Table A - Table B = Table C

[bird66]

Table A contains a group of people (each has a unique ID). From this table I have created a subset of people, Table B. I would like isolate the group of people from Table A that do not appear in Table B.

Table A - Table B = Table C

Not sure how to do this! Thanks.

[orange]

Why? If you have a table of uniquely identified people, why do you want to isolate parts?

Just a question on my part. There may be some great reason, but many times we see the opposite--- I have 3 tables --- clients, prospects and contacts is there some way I could merge them????

You can always run a query to filter the subset you want and still have only 1 People table.

[bird66]

I figured it out - I used the unmatched query wizard. thanks.

[orange]

I agree, that is How, but could you give a brief description of Why?

[bird66]

Table B, the subset, contains a list of people from predefined geographic areas. My client wants to see a a list of those who do not fall into those areas.

[orange]

My client wants to see a a list of those who do not fall into those areas.

Did you consider a query?

Select YourTable.* from YourTable Where Region Not In ("Reg1","Reg2","Reg3")