Compare tables for duplicates

I have two tables, both have a field with the same data type and length (11 digit numbers).

I want to compare the two tables.

Table A is my master table.  Table B is the one I want to compare A against.

I created a field in Table A called Duplicate. Basically, I want a comparison of B against A, and when there is a match (duplicate), It will populate the Duplicate field with something (1, Yes, etc).

Thanks in advance. 

.

Relevant Pages

  • Re: generating a random six digit number
    ... I have to come up with a random six digit  SPC code. ... In order to avoid duplicates you need to avoid using random numbers, ... The easiest permutation to use is some ... Do not change the key unless you want to risk duplicate ...
    (sci.crypt)
  • RE: Customized Autonumbering
    ... Is not returning the 3 digit day. ... Dim strReturn As String ... 'Do a DLookup in the table for an existing duplicate value. ... 'Duplicate Number, increment ...
    (microsoft.public.access.modulesdaovba)
  • Re: Duplicating
    ... The field is a 17 digit text field example "W915BQ43220851XXX". ... If not, no big deal, this is a transportation code for cargo, ... preparing and transporting air ... be a duplicate once used it is never good again. ...
    (microsoft.public.access.forms)
  • Re: Compare tables for duplicates
    ... both have a field with the same data type and length ... >(11 digit numbers). ... > I want to compare the two tables. ... > comparison of B against A, and when there is a match (duplicate), It ...
    (comp.databases.filemaker)
  • Re: Looking for a PHP PIN Number generator
    ... If I generate a range of 16 digit numbers, what chances are there for a ... I wrote a quick program to check, and it showed you would have to generate 117,741,003 random numbers to have a 50% chance of getting a duplicate. ... digit PIN for my ATM card. ... And I don't think someone's going to guess a 16 digit PIN in any reasonable time, even if it is computer generated. ...
    (comp.lang.php)