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 (2) |
Tidak ada komentar:
Posting Komentar