Hello all:
I currently have a report setup and the higher ups would like to generate the report by quarters or YTD when ever they feel like it.
I've created buttons that allow them to simply click for the prior quarter, the current quarter, or YTD. The problem is I would like the report title to specify which time period the data reflects. For example, if today I press the button for the current quarter report I would like the report title to include "1st Quarter" or something like that.
The criteria I'm using to pull the data is below, but I'm not sure if that matters or not. Year([Reports]![CPE]![CourseDate])=Year(Now() And DatePart("q",Date())=DatePart("q", Now())
Access 2010
Thanks in advance for any help.
I currently have a report setup and the higher ups would like to generate the report by quarters or YTD when ever they feel like it.
I've created buttons that allow them to simply click for the prior quarter, the current quarter, or YTD. The problem is I would like the report title to specify which time period the data reflects. For example, if today I press the button for the current quarter report I would like the report title to include "1st Quarter" or something like that.
The criteria I'm using to pull the data is below, but I'm not sure if that matters or not. Year([Reports]![CPE]![CourseDate])=Year(Now() And DatePart("q",Date())=DatePart("q", Now())
Access 2010
Thanks in advance for any help.
Dynamically generating a report title based upon a date criteria
