Hi all can you please assist me,
I would like to split my records into different year and month see below I want figure one to be split into different categories but this must all display on one page.
my current result set is like this:
Date Year Date Month Instructor Num Of Members
2013 November Jones 57
2013 November Smith 40
2013 November Moreleta 55
2013 November James 65
2013 November Soodie 65
2014 January Jones 47
2014 January Smith 55
2014 January Moreleta 60
2014 January James 73
2014 January Soodie 68
2014 February Jones 48
2014 February Smith 60
2014 February Moreleta 66
2014 February James 75
2014 February Soodie 68
I want them to be split like the one below. Can any of you assist me in doing this.
Date Year Date Month Instructor Num Of Members
2013 November Jones 57
2013 November Smith 40
2013 November Moreleta 55
2013 November James 65
2013 November Soodie 65
2014 January Jones 47
2014 January Smith 55
2014 January Moreleta 60
2014 January James 73
2014 January Soodie 68
2014 February Jones 48
2014 February Smith 60
2014 February Moreleta 66
2014 February James 75
2014 February Soodie 68