Comparing Values

L

lewysjones

I need a query to compare the Rev Number (dont worry what that is) in
one table with the other Rev number in another table, having little
experience in queries I am really stuck what I need to write, so any
help is most welcome

Basically I want the database to show when one Rev number is different
from the other, if it helps produce the query the table names are:
ISOs-PDOCS_tbl and Table_ISO_Connections_tbl, I dont really mind how
the database shows these numbers are different but as long as it does,
the Rev numbers are up to 2 characters long.

thanks in advance
 
B

Barry Gilbert

Is there some key field that's common to both tables? If I understand you
correctly, you want to see records where the Rev is different from the same
key between two table.
If this is correct, create a query with both tables. Draw a one-to-one
relationship between the two key fields. Add the Rev column from
ISOs-PDOCS_tbl. In its criteria field put:
<>Table_ISO_Connections_tbl.Rev

Barry
 
Top