Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Finding duplicate records from two separate records
Message
 
À
14/01/2002 17:12:45
Information générale
Forum:
Microsoft Office
Catégorie:
Access
Divers
Thread ID:
00604607
Message ID:
00604628
Vues:
21
Thank you. Just what I needed!
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform