| Software > Access Queries > Deleting Duplic... |
|
| << 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:
|
=?Utf-8?B?TUo=?= <MJ@[ |
2008-08-07 07:09:02 |
|
"bcap" <bcap |
2008-08-07 15:25:46 |
|
=?Utf-8?B?TUo=?= <MJ@[ |
2008-08-07 07:51:01 |
|
"bcap" <bcap |
2008-08-08 07:13:50 |
|
Post A Reply:

|