Limiting records

[Wi Tawhai]

I am using Access 97. Situation:In a fishing competition, Man A catches 5 different types of fish a,b,c,d,e,f weighing 10.9,8,7,6,5kg each. Man B catches 6 different types of fish a,b,e,f,g,h weighing 10,8,7,6,5,4Kgs each. Unfortunately the rules state that each angler can only register 4 different types of fish. The anglers obviously will have registered the 4 heaviest fish they have caught.
Question: How can I get access to only register the 4 heaviest fish per angler? ope someone can help. I have built this database using basic access commands and not by using SQL language.
Thanks
Wi

 

[Tanis]

You will need to use either SQL or a query to retrieve the information. Have a look at the TOP function in help.That should get you what you want.