Karaoke Scene's Karaoke Forums
https://mail.karaokescene.net/forums/

Microsoft Access (2000) question
https://mail.karaokescene.net/forums/viewtopic.php?f=1&t=7819		 Page 1 of 1
Author:  knightshow [ Sat Sep 02, 2006 7:29 pm ]
Post subject:  Microsoft Access (2000) question
Heya Access or database gurus...

I've been playing around with my database, and I THINK I know what I want to do to remove duplicates.

I have ONLY a few fields:

Disc (key id) (this is disc and track number)
Artist
Title
Date
and now ... DUPE (with a y/n)

I'm trying to generate a report where the NON checked entries will not appear...

How would I go about doing this? I've looked in the properties... haven't seen the one that really jumps out at me.

On my Master book, I want all listings, but I make the duplicate entries invisible...

Any idears??

Thx
Author:  Keith02 [ Sat Sep 02, 2006 7:33 pm ]
Post subject:  Re: Microsoft Access (2000) question
knightshow @ Sat Sep 02, 2006 9:29 pm wrote:
Heya Access or database gurus...

I've been playing around with my database, and I THINK I know what I want to do to remove duplicates.

I have ONLY a few fields:

Disc (key id) (this is disc and track number)
Artist
Title
Date
and now ... DUPE (with a y/n)

I'm trying to generate a report where the NON checked entries will not appear...

How would I go about doing this? I've looked in the properties... haven't seen the one that really jumps out at me.

On my Master book, I want all listings, but I make the duplicate entries invisible...

Any idears??

Thx
See if this helps:

http://support.microsoft.com/default.as ... -US;209183

Or this:

http://www.databasejournal.com/features ... hp/3077791

this one looks easy:

http://www.ehow.com/how_13574_wizard-create-find.html

Here is a shareware app that is designed to do it for you....take care to test it first!

http://www.topshareware.com/Del-Dupli-F ... -18119.htm
Author:  knightshow [ Sun Sep 03, 2006 9:11 am ]
Post subject:  Re: Microsoft Access (2000) question
Thanks Keith... I'm by no means a Database person!!
Author:  Keith02 [ Sun Sep 03, 2006 10:07 am ]
Post subject:  Re: Microsoft Access (2000) question
knightshow @ Sun Sep 03, 2006 11:11 am wrote:
Thanks Keith... I'm by no means a Database person!!
Well, Access is a good data base, but the dups issue in one problem all users eventually scream about...Try the shareware solution I linked you to, but try it first on a copy of your data base.

I'm typing this on a machine I just built a friend...he's headed over to pick it up, so yeah for me!....He's got a fresh machine with a clean drive and Avast anti-virus installed, with winduhs fully updated.....Let's see how long it takes him to get it loaded with virus anyway LMAO

I also upgraded him to IE7 RC-1, so many that will help keep him clean.
Author:  Mike W. [ Mon Sep 04, 2006 12:29 am ]
Post subject:  Re: Microsoft Access (2000) question
The answer is very simple, Matt. You set up a QUERY from your songbook TABLE with all the fields you need for your report plus the DUPE field (which I assume is a yes/no type field).  You then set the criteria as: Like "0" for the DUPE field, as this will give you all the versions in your songbook.  You then open up DESIGN VIEW for your REPORT, go to the report properties and set the record source to the QUERY you just created.  This will "hide" the dupes in your singer's songbook.
Author:  knightshow [ Mon Sep 04, 2006 6:39 am ]
Post subject:  Re: Microsoft Access (2000) question
Thanks Mike... I knew it had to be a typed in condition, but I had no idea what it would be...

May I email you with further questions if I have them?
Page 1 of 1 All times are UTC - 8 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/