| Karaoke Scene's Karaoke Forums https://mail.karaokescene.net/forums/ |
|
| Removing duplicate songs in access https://mail.karaokescene.net/forums/viewtopic.php?f=1&t=4940 |
Page 1 of 1 |
| Author: | pkircher [ Mon Jun 13, 2005 9:05 pm ] |
| Post subject: | Removing duplicate songs in access |
I remember seeing apost in here a few months back where sombody described a porcess to take songs out of sax n dotty show hoster, into access remove the duplicates and then import into kjpro. I've been searchin the forums for an hour and I cannot find the info. Any help would be appreciated. |
|
| Author: | marty3 [ Wed Jun 15, 2005 6:04 pm ] |
| Post subject: | Re: Removing duplicate songs in access |
I've done it in Excel where I added a field to flag duplicates, then sort or auto filter to screen them out. From Excel the non-duplicate remains can be read into Access for report creation. I suppose within Access one could also just add a condition like duplicate <> "Y" (I use Y and N as the dupe flag). I'm pretty rusty in Access, and lack skillz. Have reverted back to just printing from Excel. I also added a field to designate Holiday and Foreign categories to produce separate listings of those in my book. |
|
| Page 1 of 1 | All times are UTC - 8 hours |
| Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |
|