how to - create report but first change some data

[kaul1jos]

I have a database with some tables.
I need to print a selection from one of the tables but first I need to know the ranking before printing.

So, the table has records with:
naam, gemiddelde, wedstrijdpunten

I need first add some extra info:
1)
the one with highest gemiddelde has x points and the one with the lowest gemiddelde has 1 point
2)
the one with highest wedstrijdpunten has x points and the one with the lowest wedstrijdpunten has 1 point
3)
make a sum of the two extra info points

after that I want to create and print the report with the guy who has the most points at top and the guy with the lowest points at the bottom of the report.

thanks in advance for your help

 

[jrbarnett]

Hi,

Do you need to store items 1 and 2 after calculation for use at a later date?

John

 

[kaul1jos]

Hi John,

I need this everytime (every week) but then the calculations can be diferent just before printing.

Thanks
Jos