>Can anyone tell me if it's possible to search two separate tables in Microsoft Access and find records that are the same. For instance searching a field I have labelled phonenum in both TableA and TableB. Would a crosstab query do that and how would I go about in creating it?
>Thanks!
>Max
An INNER JOIN on all fields should give you what you want. In other words, a query that returns the matches from both tables where all fields are the same. Something like this should work:
Select Table1.* From Table1 Inner Join Table2 On Table1.fld1=Table2.Fld1 And Table1.fld2=Table2.fld2 .. etc.
HTH