Connecting Tech Pros Worldwide Forums | Help | Site Map

Join & Minus Tables in Access

Bibic0711
Guest
 
Posts: n/a
#1: Nov 12 '05
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?

Trevor Best
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Join & Minus Tables in Access


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?
Closed Thread


Similar Microsoft Access / VBA bytes