Could anybody help me out regarding ms access report.

I have an Access form in which I have different fields such as Badminton (score 1) , rugby (score 0), golf (score 2)for each student.

I need to create a report for individual students in which Badminton and

golf are alone visible. In a nut shell, the report or the print out shouldn't show any activity with 0 score.

tks and regards