3 replies
by dklippert
Rather than create another Table, use a Query.
Create a Query based on the table containing the scores.
Click on the Totals icon on the toolbar
Duplicate the Scores field in the Query.
Click in the Group by box and make one field Max and the other Min.
Eliminate any superfluous fields.
For an Example, go to the Northwind.mdb sample database. Open the Employee Sales by Country Query.
Duplicate the SalesAmount: SubTotal field.
Change one to MaxSalesAmount and the other MinSalesAmountDelete all the other fields, except for Country.
Click on the Total icon and then make the "Group by" of one SubTotal Max, the other Min
Run the Query. (Just hit enter when asked for dates)
by jgreer
by jgreer
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending