Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
edb2003
Yak Posting Veteran
66 Posts |
 Posted - 2005-07-11 : 15:43:54
|
| Greetings, I have an access file and would like to gather all duplicate records by account numbers. Is there some sorto of script that can allow me to do this in Access. I have a column with account numbers I want to grab the duplicates and place it in another Access table.Can anyone tell me how to do this.I really appreciate your help :)Thx,Edb |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-07-12 : 01:13:47
|
| [code]Select accountno, count(*) as counting from yourtable group by accountnohaving count(*)>1[/code]will give you the accountnos with duplicatesMove that result to ohter tableMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Gathering Group Records in Access