I have a report which lists when a series of individual audits have been completed.
Each individual audit has a completion date.
I would like to have a text box in the page header of this main report which groups the individual audits into Months
e.g if any audit completion date is between 01/01/2016 and 31/01/2016 the the text box will show JANUARY 2016
if any audit completion date is between 01/02/2106 and 28/02/2016 te text box will show FEBRUARY 2016 etc etc
Can this be done ?