Can a single participant make the lists for more than one fish? If so, create a query by participant, tournament, type of fish, and max weight. You may need to join this query back to tblCatch to get the length of the fish since you might have some skinny ones.
Use this as the record source of your report.
Take this advice from a fisherman named Duey Hookom ;-)
Duane Hookom MVP
MS Access
----------------------------------------
> From: leathaj@hotmail.com
>
>
> I have the following tables: tblParticipants, with a key field ParticipantID (autonumber), Participant Name, Address, Phone, email; tblFish, with fishID and fish name (King Salmon, Brown Trout, etc.); tblTournament with tournamentID and tournament name (derby, kayak, pro, amateur); and tblCatch, with ParticipantID, TournamentID, fishID, fish length and fish weight. What I need to create is a report for each tournament which lists the top ten fish of each type by length and weight, along with the participant's name, with only the largest fish of each type per participant. I have a totals query which groups by tournament and lists the top ten fish of each type. What I need is to eliminate all but the largest fish caught by each participant. Would the totals query for the largest fish per fisherman be based on my existing totals query?
>
> Thanks again for your help!
> Leatha Johnson
>
> To: ms_access_professionals@yahoogroups.com
> From: duanehookom@hotmail.com
> Date: Mon, 11 Feb 2013 22:32:25 -0600
> Subject: RE: [MS_AccessPros] Delete a duplicate entry - sort of
>
> I think you should provide significant information about your tables, fields, and data. I expect you could create a totals query with the largest fish per fisherman.
>
> Duane Hookom MVP
>
> MS Access
>
> ----------------------------------------
>
> > To: ms_access_professionals@yahoogroups.com
>
> > From: leathaj@hotmail.com
>
> > Date: Mon, 11 Feb 2013 18:39:01 -0600
>
> > Subject: [MS_AccessPros] Delete a duplicate entry - sort of
>
> > I've been asked to develop a database to track the fish caught in a local fishing derby. One of the lists will show the top ten fish caught. The kicker is this - if one fisherman caught more than one of these top ten, only the largest fish should be included in the list. I can delete the duplicates, but I don't know how to eliminate all but the largest. How should I go about this?
>
> > TIA for all help (we live on Lake Michigan, so fishing is a big deal here!).
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar