Help with queries

[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???

 

[John Vinson]

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

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

 

[Guest]

Sure no worries

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

Anythoughts would be appreciated.

 

[Guest]

Thanks very much John you have been very helpful much appreciated.

cheers Joe Bryant