HELLO EVERY ONE,

I have a table in MS Access that has records containing:

YEAR, THEME, COUNT OF THEMES and other data.

I know how to create a report but i am not able to do this . I need a report in MS Access that groups on year but is formatted so i can see each
year next to each other, rather than below each other with themes
listed under in order by count.

1998 1999 2000 etc
cancer 23 cure 37 smoking 45
cure 19 smoking 35 testing 37
testing 12 testing 27 cancer 23