How to Compare my Tables

[Guest]

hiiiiiiiiiii
hope u may be ok .
so dear friends i have a problem with two tables. i do want to compare them.
let me give u the examples
i have two table
table1 consist of student RNo from 1 to 400
in table 2 i have Rno like 34,56,20,30 1,5,90 etc and now i want to compare
tabl2 Rno with the Table1 to ensure that if table2 Rno exist in table1 then
in a different field i should get yes in front of it's Rno.
hope u have got me what i mean.
Thanks Alot in Advance.

 

[Larry Linson]

In the Query Builder, add both tables. Click on the RNo field in Table2 and
drag to the RNo field in Table1. Leave the Join properties as "only when the
record appears in both tables". You can check this by right clicking on the
join line and choosing Join Properties.

Drag the RNo down to the grid. Click the ! button to run the query. This
will list all the RNos that match in both Tables.

If you really, really want the other field, create a calculated field such
as

IsIt: "Yes".

But you should realize that every displayed record will be a "Yes".

Now my question to you is, what are you going to do about records that
appear in both tables? It seems to me that just having a list of them is not
very useful.

Larry Linson
Microsoft Access MVP