Show only Current Year on Report "Newf via AccessMonster.com" <u24600[ at ]uwe> 28.07.2006 13:24:41 I was wondering is there a way to show only the current year (YYYY) on a report??? Thanks in advance cw -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200607/1

RE: Show only Current Year on Report Jeff C 28.07.2006 14:27:02 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") -- Jeff C Live Well .. Be Happy In All You Do "Newf via AccessMonster.com" wrote: [Quoted Text] > I was wondering is there a way to show only the current year (YYYY) on a > report??? > > Thanks in advance > > cw > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200607/1 > >