Re: Combine tables while excluding duplicate entries?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 01/14/05 

Date: Fri, 14 Jan 2005 05:29:59 -0800

Depends on your definition of "similar".

When you create a query, you can choose which fields you want to see. If
you choose "identical" fields from two different tables (in two different
queries), you could use a UNION query. Here's an excerpt from Access HELP
on "Union":

    By default, no duplicate records are returned when you use a UNION
operation; however, you can include the ALL predicate to ensure that
all records are returned. This also makes the query run faster. 

-- 
Good luck
Jeff Boyce
<Access MVP>
"RacinMyLancer" <RacinMyLancer@discussions.microsoft.com> wrote in message
news:E006E9DF-5C20-42D2-8A08-DE6BA2F7A0C0@microsoft.com...
> I don't mean to cross-post, but I realized I posted my original question
in
> the wrong category (Access General Questions... moderator, feel free to
> delete :))
>
> I'm using Access 2002:
>
> I have two similarly structured tables which I would like to combine,
while
> excluding duplicate records. I would like to control the criteria by which
a
> duplicate record is deemed such (using multiple fields for duplicate
> searching, rather than just one), and, if possible, be able to review and
> make changes to the records selected for (or excluded from) the table
merger
> before the final combination takes place.
>
> I would think that Access would have this functionality built in, as I
know
> other database applications do. If it already exists, can someone point me
> toward how to do it?
>

Relevant Pages

  • Re: Identifying Duplicate Records
    ... response to what appeared to be a barely relevant question. ... in the list of options is Find Duplicates query. ... or bring up the dupe records to look at them. ... have a find duplicate records wizard. ...
    (microsoft.public.access.formscoding)
  • Re: Identifying Duplicate Records
    ... Indeed, the duplicate records ... Discovering the Find Duplicate query, ... or bring up the dupe records to look at them. ... have a find duplicate records wizard. ...
    (microsoft.public.access.formscoding)
  • Re: Identifying Duplicate Records
    ... the duplicate records problem represented one of the few occasions ... the Find Duplicate query, however, has allowed me to plug another gap in my ... or bring up the dupe records to look at them. ...
    (microsoft.public.access.formscoding)
  • Re: Identifying Duplicate Records
    ... Whatever you use, you then can use the results to flag the dupes for review in one way or another, or bring up the dupe records to look at them. ... This is a tricky little query to understand, from a beginner to intermediate point of view. ... To find our duplicate records we build a query inside the IN function that will return only those values that occur more than once in the table. ... then comparing the results but the details of ...
    (microsoft.public.access.formscoding)
  • Re: Deleting duplicate records
    ... FROM Vessel X WHERE A.Vessel=X.Vessel AND ... It is suggested by Roger Carlson http://www.rogersaccesslibrary.com who is ... You will see full explanation of how to eliminate duplicate records ... > duplicate records where have created Totals query to find Distinct Records ...
    (microsoft.public.access.queries)