HI,
I have a Query with 3 columns
ID---Week No---Activity
Is there a way to display this information in grid form with Week No as column headings, ID as row Headings and activity as the content.
Activity would be walk, run, cycle, drive fly
ID would be jack, jill, joe, arthur, frank, molly
Week no would be wk1, wk2, wk3 etc.
Many thanks