N Newf via AccessMonster.com Jul 28, 2006 #1 I was wondering is there a way to show only the current year (YYYY) on a report??? Thanks in advance cw
I was wondering is there a way to show only the current year (YYYY) on a report??? Thanks in advance cw
G Guest Jul 28, 2006 #2 When I have restrictions like that, either current year or current month, I modify the query the report is based on to include a new column. Current Month: Format([mydatefield],"mmmm") OR Current Year: Format([mydatefield],"yyyy") Then in the criteria - format(date(),"yyyy") OR format(Date(),"mmmm")
When I have restrictions like that, either current year or current month, I modify the query the report is based on to include a new column. Current Month: Format([mydatefield],"mmmm") OR Current Year: Format([mydatefield],"yyyy") Then in the criteria - format(date(),"yyyy") OR format(Date(),"mmmm")
