Connecting Tech Pros Worldwide Help | Site Map

Join & Minus Tables in Access

  #1  
Old November 12th, 2005, 10:22 PM
Bibic0711
Guest
 
Posts: n/a
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?
  #2  
Old November 12th, 2005, 10:22 PM
Trevor Best
Guest
 
Posts: n/a

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 Threads
Thread Thread Starter Forum Replies Last Post
Join & Minus Tables in Access Bibic0711 answers 1 November 12th, 2005 10:49 PM