Duplicates Query Question

[P B via AccessMonster.com]

I have a large list of names in a database table which includes things like
account # and Date of Birth, Address, etc.

I want to run a query looking for possible duplicates. I don't have the
duplicate query 'query selection', the only two Query choice are from Design
or Wizard and so I'm needing to do it from scratch.

I want to match first letter of the last name with the date of birth and
produce a list.

Please advise. Thanks.

 

[KARL DEWEY]

This was tried with very little data. Here are three queries to build.
First --
SELECT Left([LastName],1) AS LastInitial, FirstTable.*
FROM FirstTable;

Second --
SELECT Left([LastName],1) AS LastInitial, SecondTable.*
FROM SecondTable;

Third --
SELECT FirstQuery.LastName, SecondQuery.LastName, FirstQuery.DateOfBirth,
SecondQuery.DateOfBirth
FROM FirstQuery INNER JOIN SecondQuery ON FirstQuery.LastInitial =
SecondQuery.LastInitial
ORDER BY FirstQuery.LastName, SecondQuery.LastName, FirstQuery.DateOfBirth,
SecondQuery.DateOfBirth;