Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Queries > Deleting Duplic...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 41220 of 43104
Post > Topic >>

Deleting Duplicate Records, Keeping First Occurance

by =?Utf-8?B?TUo=?= <MJ@[EMAIL PROTECTED] > Aug 7, 2008 at 07:09 AM

My problem is from a list of records of transactions where I have a number
of 
duplicates throught out any given month.  I have devised a way to sort the

dups out into a separate table (containing ALL of the dups for that
month), 
grouped and sorted in the order I want to see them as dup.  Now I need to 
weed out all dups EXCEPT the first one of each different

tblDUPS
     FC     AT      Enc            Age      AcctBal         Hold
*   A       DUP    4960002     0-30     $1,514.75     BDH
     A       DUP    4960002     0-30     $1,514.75     BDH
     A       DUP    4960002     0-30     $1,514.75     IVH
*   C       DUP    5000000     365+    ($160.48)      BDH
     C       DUP    5000000     365+    ($160.48)      No Charges
     C       DUP    5000000     365+    ($160.48)      No Charges
*   B       DUP    5210002     0-30     $51.14          BDH
     B       DUP    5210002     0-30     $51.14          BDH
     B       DUP    5210002     0-30     $51.14          IVH

In the table above, duplicates are define by fields: FC; Enc; Age; & 
AcctBal.  I want to keep the first occurance (*'d) and I want to delete
the 
others.  The resulting list should look like:

tblDUPS
     FC     AT      Enc            Age      AcctBal         Hold
*   A       DUP    4960002     0-30     $1,514.75     BDH
*   C       DUP    5000000     365+    ($160.48)      BDH
*   B       DUP    5210002     0-30     $51.14          BDH

How can I do this efficiently?

Thank you in advance for your insight and assistance.
  
-- 

MJ
 




 4 Posts in Topic:
Deleting Duplicate Records, Keeping First Occurance
=?Utf-8?B?TUo=?= <MJ@[  2008-08-07 07:09:02 
Re: Deleting Duplicate Records, Keeping First Occurance
"bcap" <bcap  2008-08-07 15:25:46 
Re: Deleting Duplicate Records, Keeping First Occurance
=?Utf-8?B?TUo=?= <MJ@[  2008-08-07 07:51:01 
Re: Deleting Duplicate Records, Keeping First Occurance
"bcap" <bcap  2008-08-08 07:13:50 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Thu Nov 20 19:15:38 CST 2008.