report with query and macro

[kaul1jos]

I have a database with queries and reports.
Now i would like to have a report with a query but firt i need to run 1 or to macro's to fill up variables or an array.

dbfields: name, nr(unique), moy, points

The array must be filled with nr, moy, points from the record in the query and place1, place2, totalpoints:

The array will be sorted first on moy and after that place1 will be filled up from 1 to .....
The array will be sorted second on points and after that place2 will be filled up from 1 to .....
The array will totalpoints will be filled with place1+place2

After the macro was runned the report must display:
name, nr, moy, points, place1, place2, totalpoints.

I've never run macro's from within reports, so who can help me with this problem?

Thanks