Thanks for reading my problem.
I have an access table and a query in which I've a list of Student names and their cca profiling such as Badminton (this field is an integer field) Rugby, Golf , Soccer etc.,.
Student Badminton Rugby Golf Soccer Total
xxxx 1 0 2 0 3
It's working fine upto this point.
If I want to generate a report like the below one
Student xxxx
Badminton 1
Golf 2
Is it possible. Pl. help me out. Thanks and regards