Join & Minus Tables in Access

I am having problem on following situation, any comments are welcome.

I have this table A which contents most of the data, that needs to be
query based on a name field in table B and was linked to table A by an
index. Then I need to minus another table C's data from table A with
the same index link from table B. How do I query from the situation
and Access-usable?

Bibic0711 wrote:
[color=blue]
> I am having problem on following situation, any comments are welcome.
>
> I have this table A which contents most of the data, that needs to be
> query based on a name field in table B and was linked to table A by an
> index. Then I need to minus another table C's data from table A with
> the same index link from table B. How do I query from the situation
> and Access-usable?[/color]

From what I think you mean, you want to use the Find Non matching query
wizard using tables a & c then join b in.

--
But why is the Rum gone?