+ Reply to Thread
Results 1 to 4 of 4

Mutiple records -delete everything but Fisrt record

  1. #1
    Forum Contributor
    Join Date
    05-04-2016
    Location
    London
    MS-Off Ver
    MS Office Excel 2010/2013
    Posts
    323

    Mutiple records -delete everything but Fisrt record

    Hi all,

    Firstly thanks all for your help you guys doing - i am hoping someone have answwr to my issue .

    I have this issue I deal with excel file with 90 MB and working with that larg file is obviously a challanging performance to excel and in that deleting duplicate records other than 1st is big challange .. is there way we can do this in MS access -deleteing everyhting other than 1st record ? .


    Thanks & regards,
    Hudson

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,260

    Re: Mutiple records -delete everything but Fisrt record

    Create a new table within Access. For your field that you want no duplicates, set the Indexed to Yes (No duplicates). On the External Data Tab, select your current Table you wish to get and import into your new table.

  3. #3
    Forum Contributor
    Join Date
    05-04-2016
    Location
    London
    MS-Off Ver
    MS Office Excel 2010/2013
    Posts
    323

    Re: Mutiple records -delete everything but Fisrt record

    Hey friend ...thanks for your reply and i would like to share same basic file of which i am talking .. i have mutiple records in the file, i want create helper as uniqe ID in column "Q" using that, column "R" tells which nth time the record is appering .... and can we do similar stuff with the access ?. casue i have huge data like this and out of which i wanted only anything with "1" ...
    Attached Files Attached Files

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,260

    Re: Mutiple records -delete everything but Fisrt record

    Using Power Query, I was able to achieve what I believe you are looking for in seconds. I brought your file into Power Query (This is an available free download if you are running 2010 as your profile indicates.) I filtered out column R for only 1's. I then filtered Column Q for duplicates. This brought the file down to about 4400 runs from 39K. Here is the Mcode but the file is to large to upload.

    Table name is "Account." If you are unfamiliar with PQ, then click on the links in my signature to learn more. It is perfect for your needs.
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Find the initial parent record based on the records in the last child records
    By Journeyman3000 in forum Access Tables & Databases
    Replies: 0
    Last Post: 03-30-2017, 08:46 PM
  2. [SOLVED] excel navigate records if end record display end of record
    By aarona in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2017, 06:04 AM
  3. Delete Duplicate records but keep 1 record with most recent date
    By bcn1988 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-07-2015, 02:28 AM
  4. [SOLVED] Macro - Identify Record sets and delete related Records
    By haleakala17 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2014, 04:16 PM
  5. Mail Merge - Mutiple records per page
    By mivanows in forum Excel General
    Replies: 0
    Last Post: 08-27-2012, 02:53 PM
  6. delete duplicate records after totaling a field from each record
    By HarrySpencer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2007, 09:49 AM
  7. How to delete duplicated records. Each record has four lines
    By Arcesio Hernandez in forum Excel General
    Replies: 2
    Last Post: 07-26-2005, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1