Help with queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to differentiate between data in two tables that are the same
and those that are different. Currently from what i can infer is that
microsoft access only allows people to display data between two tables (in a
seperate table) that are the same and not the different sets of data. Is
there any way around this???
 
Is it possible to differentiate between data in two tables that are the same
and those that are different. Currently from what i can infer is that
microsoft access only allows people to display data between two tables (in a
seperate table) that are the same and not the different sets of data. Is
there any way around this???
Click to expand...

There is an "Unmatched Query Wizard" which will find those records in
TableA which have no corresponding match in TableB. As Tom asks,
what's the situation? Could you give some examples of the data, and
what you would like to find? Does each table have a Primary Key,
and/or do you have any relationship established between the tables?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Sure no worries

John i wrote an example in a query posted just below mind in which tom
reponded too.

Anythoughts would be appreciated.
 
Back
Top