If you run one query to show the largest fish caught by each individual fisherman, then sort that by fish size, and limit the query to a "top 10" - you would have that result every time in a single query.
--- In MS_Access_Professionals@yahoogroups.com, Leatha Johnson wrote:
>
>
>
>
> 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!).
>
>
>
> [Non-text portions of this message have been removed]
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
Tidak ada komentar:
Posting Komentar