Hi all, I've had a mosey about but can't find a solution to this puzzle. The Capita man said it was doable, but difficult...
I want to produce a report for each form tutor in the school. The report is to contain students in rank order of attendance in one column and rank order of conduct in a second.
Obviously a new page for each form tutor. (Data on show is Name/Conduct and in another column Name/Attendance).
I've tried various permutations of an RTF form and mail merges but my knowhow is a bit limited and I can't make it work.
Any thoughts?
