duplicate records

  • Thread starter Thread starter emailcad
  • Start date Start date
E

emailcad

I HAVE A DATABASE THAT I AM WORKING WITH ABOUT 200000 ITEMS I HAVE ISOLATED
THE DUPLICATES INTO ONE QUERY IS THERE ANY WAY I CAN CONSOLIDATE THE
DUPLICATE ITEMS TO ONE LINE EACH AND TOTAL THE OTHER FIELD VALUES?
THANKS
CHRIS
 
YES. Or perhaps MAYBE.

You can use a totals query to consolidate the data, you cannot have the
primary key in the query as that will defeat the grouping.

Open a new query
-- Select your table
-- Add the fields you want to see
-- Select View: Totals from the menu
-- Change Group by to SUM under the fields you want to total
-- Run the query and see if it gives you the desired results.

If you want to screen out records BEFORE you add them up
-- add the field(s) you want to apply criteria to
-- Change Group By to WHERE
-- enter the criteria

If you want to screen out records after they have been totaled insert the
criteria under the field as it is grouped or summed.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top