League Tables

  • Thread starter Thread starter Duane Hookom
  • Start date Start date
D

Duane Hookom

Create a query that returns one record:
SELECT TOP 1 POINTS as MaxPoints
FROM tblLeagueTable
ORDER BY POINTS DESC, TEAM;

This should return one record with one field containing the top number of
points. Add this query to your report recordsource and don't join it to any
other table. Add the MaxPoints column to your query so you can subtract
Points from it.
 
Garry said:
I want to print Football league tables

Points Difference
Saints 140 0
Bills Bulls 120 - 20
Royals 90 - 50

The report is grouped by Points Descending
How can I calculate the difference in points from the table leader
Click to expand...


Put a text box named txtMaxPoints in the Report Header and
set its expression to =Max(Points)

Then the Difference text box in the detail section can use
the expression =txtMaxPoints - Points
 
Hi all

I want to print Football league tables

Points Difference
Saints 140 0
Bills Bulls 120 - 20
Royals 90 - 50

The report is grouped by Points Descending
How can I calculate the difference in points from the table leader

Any thoughts welcome, many thanks Garry
 
Thank you both for your time, Garry

Marshall Barton said:
Put a text box named txtMaxPoints in the Report Header and
set its expression to =Max(Points)

Then the Difference text box in the detail section can use
the expression =txtMaxPoints - Points
Click to expand...
 
Back
Top