Re: Question Regarding Combining Duplicate Records

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thank you for your response, however I tried that, but because I have
other transactions that are not duplicates, I don't know how to bring
the respective non-duplicates into the duplicate query so that I can
view all of my transactions together, by transaction. I am in extreme
gratitude for your help. Please let me know if this response is
confusing



Klatuu wrote:
Waht you need is a Totals query.
Create a query in the query builder that contains the field you identify.
Click on the icon on the tool bar that looks like the Greek letter Sigma
(sort of).
You will see a row added to the query builder.
For all the rows execpt Revenue, select Group By. For Revenue, select Sum.
--
Dave Hargis, Microsoft Access MVP


"wwachsberger@xxxxxxxxx" wrote:

I have a situation where I have quasi-duplicate data which looks like
the following:

Unique ID Name Location Color Revenue
1 A New York Green 100
2 A New York Green 200
3 A New York Green 300


There are about 10,000 examples of seperate duplicates like this within
my database. I have written a duplicate query in order to identify all
of these quasi-duplicate records. I now wish to combine all of the
duplicates in order to have the records look like the following:

Unique ID Name Location Color Revenue
1 A New York Green 0
2 A New York Green 0
3 A New York Green 600

I can then ignore the Revenues equal to 0. Many thanks for your help
in advance!

Warren



.

Relevant Pages

  • Re: Question Regarding Combining Duplicate Records
    ... Unique ID Name Location Color Revenue ... the respective non-duplicates into the duplicate query so that I can ... view all of my transactions together, ... There are about 10,000 examples of seperate duplicates like this within ...
    (microsoft.public.access.gettingstarted)
  • Re: Deleting duplicate records/same table
    ... append the tblUniqueRecords fields into the fields on tblMaster. ... The new table without the duplicates is called ... Prepared By is the type of query I was ...
    (microsoft.public.access.queries)
  • Re: Query to delete duplicate records - but NOT original
    ... > unique records - I've already got an update query to grab the unique ... > hsc but one other field different - it ignores those 2. ... but this method of removing duplicates requires it. ... >> Access Database Samples: www.rogersaccesslibrary.com ...
    (microsoft.public.access.queries)
  • RE: Want to edit a table based on a query of a query of several qu
    ... First create union query like this -- ... Use that query in design view and add all of the other nine tables. ... This puts all the data in to a single query output without duplicates. ... Then I run a big query of all 9 queries to consolidate the data into one big ...
    (microsoft.public.access.queries)
  • Re: correct way to write the syntax for a Dlookup in a query expression in VB
    ... those that return false when the query runs to another table and leave ...    c) that you rewrite your sql select as a join checking for nulls ... DLookup; I am not). ... the duplicates may include differing information in particular ...
    (comp.databases.ms-access)